Formulas don't support this kind of formatting.

If you convert it to values, you can change the formatting the way you like.

Brad wrote:

Simple Example
in a1 =B1&", "&C1&", "&D1

B1 = Peter
C1 = Paul
D1 = Mary

in A1
Peter needs to be in Times New Roman 10 point - bold - red
Paul needs to be in Arial - underlined 12 point - blue
Mary needs to be 18 font italicizied - purple

My problem isn't quite this easy - but the concept is the same.

"JonR" wrote:

Are you trying to format the results a concatenate formula or something like
that? Interesting problem. I've not tried that before. It might help if I
knew what you were trying to format and the conditions you are trying to
satisfy.
--
HTH

JonR


"Brad" wrote:

My question is this
I want the first word to be bold - second word to be italizied - third to be
underlined ,...

Conditional formatting will change the whole cell to be whatever you specify
- but will not change only a portion of the cell to be bold another portion
to be something different

If there are no formulas - one can change the text as I described above.
Was wondering if there was a way with formulas?

"JonR" wrote:

Try using conditional formatting. It will take up to three conditions and
will format according to the criteria you specify. You can add a fourth by
setting a default format that Excel will use if none of your other criteria
are met.
--
HTH

JonR


"Brad" wrote:

Is there a way to have multiple formats in a single cell that has formula's?

What I'm doing specifically is attaching several strings together and it
would be great to be control the format in the cell.

--

Dave Peterson