Formatting text which is result of formula

[starguy]

when we join two cells or more with & or =concatenate function, how ca
this be done that result should be formatted in a way that each cells
text is individually formatted.
e.g if in cell C1 I join cell A1 and B1 containing First name and Las
name respectively by using =A1&B1, cell C1 should show result in a wa
that First name should be of black color and last name of another colo
(or any other formatting i-e bold, color, font size etc)

 

[Don Guillett]

Can't do with a formula

 

[Alan]

This can be achieved by via a macro that selects the appropriate text
in the concatinated cell and changes the font colour using
format/cells/font

 

[Gord Dibben]

Cannot be done.

Workaround is to paste special>value then manually edit the cell contents.


Gord Dibben MS Excel MVP