formatting text within CONCATENATE function

[Bowdlerb]

I would like to know if I can bold,italic etc either a letter, word or entire phrase within the TEXT - Concatenate function. An example is shown below. For example how could I make the figures only bold?

CONCATENATE("It is understood and agreed that Underwriters shall not be liable for the first ",'Pro Forma'!M7,TEXT('Pro Forma'!J90,"#,0")," of each and every claim.")

Any help would be greatly appreciated.

Bazb

[Mark W.]

On 2002-04-22 05:24, Bowdlerb wrote:
I would like to know if I can bold,italic etc either a letter, word or entire phrase within the TEXT - Concatenate function.

No. First, ou'd have to convert the formulas results into a constant value using Copy/Paste Special... Values.

[ This Message was edited by: Mark W. on 2002-04-22 06:25 ]