How to get different text formats in a concatenate function
 

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

How to get different text formats in a concatenate function
 

You can't format parts of a formula with different colours,
bold/italic/underline etc


--
Regards,

Peo Sjoblom



"Evelyn" wrote in message
...
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

How to get different text formats in a concatenate function
 

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


"Evelyn" wrote:

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

How to get different text formats in a concatenate function
 

On Fri, 8 Jun 2007 07:59:09 -0700, Evelyn
wrote:

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