Multiple Formats in a Cell (w/out use of VBA)

[imnie]

Hi everyone - does anyone know any formulas or special characters that can be used in a formula to tell the cell to BOLD a particular portion?

For example:

=CONCATENATE(Text1, Text2) ** and I want Text 2 to be shown as BOLD text.

I know that its possible to manually go in and have multiple formats, just not sure (outside of VBA) to do it w/a formula.

Thanks for any info.

 

[Mark O'Brien]

I'm going to stick my neck out and say that this cannot be done without VBA.

I'd love to be proved wrong though.