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