when we join two cells or more with & or =concatenate function, how can
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 Last
name respectively by using =A1&B1, cell C1 should show result in a way
that First name should be of black color and last name of another color
(or any other formatting i-e bold, color, font size etc).


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=563334

Can't do with a formula

--
Don Guillett
SalesAid Software

"starguy" wrote in
message ...

when we join two cells or more with & or =concatenate function, how can
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 Last
name respectively by using =A1&B1, cell C1 should show result in a way
that First name should be of black color and last name of another color
(or any other formatting i-e bold, color, font size etc).


--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=563334

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

Cannot be done.

Workaround is to paste specialvalue then manually edit the cell contents.


Gord Dibben MS Excel MVP

On Thu, 20 Jul 2006 11:19:34 -0400, starguy
wrote:


when we join two cells or more with & or =concatenate function, how can
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 Last
name respectively by using =A1&B1, cell C1 should show result in a way
that First name should be of black color and last name of another color
(or any other formatting i-e bold, color, font size etc).