How to Format a Nested Function (Bold)

  • Thread starter Thread starter GabrielN
  • Start date Start date
G

GabrielN

Is there a way to bold a nested function? I.E. I have the fuction like below:

="Emerging Markets"& " "&TEXT(BL962,"###.##")

Which ends up being:
Emerging
Markets
24.92

I would like to just bold the 24.92 and nothing else in the cell. Is there
anyway to do this in excel?
 
Copy and paste special as value then select the 24.92 and format to bold.

Cannot be done in a formula.


Gord Dibben MS Excel MVP
 
GabrielN said:
Is there a way to bold a nested function? I.E. I have the fuction like below:

="Emerging Markets"& " "&TEXT(BL962,"###.##")

Which ends up being:
Emerging
Markets
24.92

I would like to just bold the 24.92 and nothing else in the cell. Is there
anyway to do this in excel?
Click to expand...
Why not put "Emerging Markets" in one cell and the text formula in another?

Bill
 
Back
Top