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 |
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 |