bold certain concatenated text

**HuskerBronco** · 12-09-2009, 04:19 AM

Hey guys...

Any ideas on VBA to BOLD certain text in a concatenated cell??

Example:

The formula in a certain cell is this:

=CONCATENATE(E5,TEXT(DATA!A36," h AM/PM")," on",TEXT(DATA!A36," dddd"),",",TEXT(DATA!A36," mmmm dd"),"th")

Which produces the following desired result:
ENTRY DEADLINE: All entries must be submitted by 7 PM on Sunday, December 20th

What I want...is this:
ENTRY DEADLINE: All entries must be submitted by 7 PM on Sunday, December 20th

Also, I would prefer the "th" on the DATE to be superscripted. Is this even possible??

**DonkeyOte** · 12-09-2009, 04:33 AM

Originally Posted by HuskerBronco

Is this even possible??

I'm afraid not.

A cell containing a formula can not contain multiple formats.

You would need to use VBA to populate the cell with just the resulting value and in turn format parts based on Char positions etc... unless it's really important I would not bother.

EDIT: I just re-read your post where you clearly stated VBA ideas - sorry -- too early !

that said you would still need to dispense with the formula in the cell and calculate the same in memory - is that viable ?