Trying to make part of an output in another cell italicized.

[jsablan2]

Hello all,

I have Excel from Office XP and am using it on Windows XP Home Edition
I'm working on a program where users enter text in various cells. Fo
example:

A B
1 Name: ------
2 Date: ------

Then the text that they enter is displayed in another cell all togethe
using the following formula:

=$B$4&", "&$B$5&". "&"("&$B$6&"). "&$B$7&". "&$B$8&"
"&$B$9&"("&$B$10&"), "&$B$11&"-"&$B$12&"."

I've been trying to figure out how to italicize a specific part of thi
formula. For example, I want the text that was entered in $B$5 to b
in italics. The problem is that when I'm entering the formula above
the italics function is disabled. I've tried making the original entr
cell italics, but when the output comes out in the cell with th
formula, it's no longer in italics. Does anyone know if there is
code to enter in the formula to make a specific part itlaics

 

[Peo Sjoblom]

You can't use different formats in the same formula

 

[Earl Kiosterud]

j,

If you absolutely must do this, I think your only option may be to have an
event macro build the expression that the current formula is building in the
cell, put it in the cell (as text), then do the formatting you want. It
won't be trivial, but I think doable. Post back if you're willing to go
with a macro. Provide specifics.