G
Guest
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.
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.