concatenate and bold only part

[Deborahp]

I have concatenated 3 cells, is there a way to make only part of the new field bold?
I have put together, name, address and phone and I need to bold the name???

[HansV]

If the cell with the concatenated text contains a formula, the answer is no, unfortunately.
One workaround is to leave the name in a cell by itself and to make that bold.
If it's acceptable to replace the formula with its value, can select the name in the formula bar and make it bold.

[Deborahp]

No formula except for the concatenation.
=concatenate(i2," ",j2," ",s2)

[HansV]

Sadly, Excel doesn't let you format part of the result of a formula; you can only format the result as a whole. So you'll have to use one of the workarounds: either don't concatenate the name (cell I2) with the address and phone number, or replace the formula with its value (but then you'd have to redo it each time the name, address or phone number changes).