View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lakeside Steph
 
Posts: n/a
Default mix font styles in concatenated text

Can any one tell me how, in Excel 2003, to have certain words written in bold
typeface in a concatenated string. For example :

=CONCATENATE("I, the undersigned, ";A3;"do hereby confirm etc etc") which
gives
I, the undersigned, Joe Brown, do hereby confirm etc etc

But I want Joe Brown to be written in bold type face.

I've tried the most obvious which is selecting A3 within the formula and
clicking on the bold typeface icon (as you would in regular text not within a
formula), but it doesn't work.

Any help would be appreciated.