How to retain formats while concatenating multiple cells
 

Is this possible?

Cell A1: John Smith
Cell A2: Counselor (Italics)
Cell A3: MFCC (Bold)

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)