Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting text which is result of formula
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting text which is result of formula
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting text which is result of formula
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add commas to the result of a formula with a text operator? | Excel Discussion (Misc queries) | |||
Currency to Text | Excel Worksheet Functions | |||
convert numbers to text | Excel Discussion (Misc queries) | |||
center text in a formula result | Excel Worksheet Functions | |||
Adding text to the result of a formula? | Excel Worksheet Functions |