How to get different text formats in a concatenate function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello,

I have two text cells which I combine into one. This goes ok, but now I
have to make part of the output in bold and part not. When I try to do this
in the formula bar by selecting the specific part, the bold button remains
grey. Anybody any suggestions ?

Thank you
 
You can't format parts of a formula with different colours,
bold/italic/underline etc
 
You could do Copy > PasteSpecial > Values, to get rid of the formulas then do
formatting as you've described..........

Or, you could "simulate" something with code, but not maybe to your exact
needs...

Sub BoldMe()
ActiveCell.Characters(Start:=5, Length:=5).Font.FontStyle = "Bold"
End Sub

Vaya con Dios,
Chuck, CABGx3
 
hello,

I have two text cells which I combine into one. This goes ok, but now I
have to make part of the output in bold and part not. When I try to do this
in the formula bar by selecting the specific part, the bold button remains
grey. Anybody any suggestions ?

Thank you
Click to expand...

You can only differentially format actual text strings. There is no ability to
do what you want with the result of a formula.

You could execute the formula in a VBA Sub, and have the Sub write a text
string to the cell, which could then be differentially formatted. But the
contents of the cell must be a text string.
--ron
 
Back
Top