View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bill Sharpe Bill Sharpe is offline
external usenet poster
 
Posts: 348
Default How to Format a Nested Function (Bold)

GabrielN wrote:
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?

Why not put "Emerging Markets" in one cell and the text formula in another?

Bill