Different Font Sizes In The Same Cell

[Minitman]

Greetings,

I have a cell formula that retrieves data from three cells and puts
them together like so:

=A1&CHAR(10)&B1&CHAR(10)&C1

The CHAR(10) is a some kind of line feed to give me the stacked data
look.

Is it possible to make the display of the contents of A1 bigger then
the other two? The default font size is 10. I would like the data
from A1 to be 16.

I know it can be done if I entered just text (not a formula), but I
can't figure out how to do it in a formula,

Anyone have any ideas or suggestions as to how this can be
accomplished?

As always, any help will be appreciated.

-Minitman

 

[Dave Peterson]

If you want to keep the formula, then it's not possible. You can't do this kind
of character by character formatting with formulas.

 

[Minitman]

Hey Dave,

Thanks for the reply, I needed to know that.

The only work around I am aware of is to split the formula into
separate cell and format each differently. I was hoping to avoid
that.

BTW - Did MS make that feature available in Office 2007 by any chance?

-Minitman

 

[Dave Peterson]

Nope--not on xl2007.

Hey Dave,

Thanks for the reply, I needed to know that.

The only work around I am aware of is to split the formula into
separate cell and format each differently. I was hoping to avoid
that.

BTW - Did MS make that feature available in Office 2007 by any chance?

-Minitman

 

[Minitman]

Oh Well.....

Thanks.

-Minitman

Nope--not on xl2007.