G Guest Apr 20, 2007 #1 Is this possible? Cell A1: John Smith Cell A2: Counselor (Italics) Cell A3: MFCC (Bold)
E Earl Kiosterud Apr 20, 2007 #2 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, 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.