| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to retain formats while concatenating multiple cells
Is this possible?
Cell A1: John Smith Cell A2: Counselor (Italics) Cell A3: MFCC (Bold) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to retain formats while concatenating multiple cells
Ranmpa,
Not possible if using a formula to concatenate the three strings. I think a macro, fired by the worksheet_change event, could do the concatenation and the formatting. -- Earl Kiosterud www.smokeylake.com Note: Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome. ----------------------------------------------------------------------- "RANMPA" wrote in message ... Is this possible? Cell A1: John Smith Cell A2: Counselor (Italics) Cell A3: MFCC (Bold) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Macro for concatenating multiple worksheet | Excel Discussion (Misc queries) | |||
| retain formatting when concatenating | Excel Worksheet Functions | |||
| Concatenating Cells | Excel Discussion (Misc queries) | |||
| concatenating cells with their formats | Excel Worksheet Functions | |||
| Can you retain different text formats when merging text? | Excel Discussion (Misc queries) | |||
Linear Mode
