How to Format a Nested Function (Bold)

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?
 
G

Gord Dibben

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
 
B

Bill Sharpe

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if statements, searching for commma 5
Recording Macro - Insert Formula 2
Concantenate which keeps bold of some parts. 5
How to concatonate two words with first word in BOLD format? 3
Creating a Unique List 5
Bold format. 2
How to change format for an individual word in a cell 1
Bold a portion of concatenated string 1

Top