Different Font Sizes In The Same Cell
 

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

Different Font Sizes In The Same Cell
 

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

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

Different Font Sizes In The Same Cell
 

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



On Mon, 14 Apr 2008 18:52:49 -0500, Dave Peterson
wrote:

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

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

Different Font Sizes In The Same Cell
 

Nope--not on xl2007.

Minitman wrote:

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

On Mon, 14 Apr 2008 18:52:49 -0500, Dave Peterson
wrote:

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

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

Different Font Sizes In The Same Cell
 

Oh Well.....

Thanks.

-Minitman

On Mon, 14 Apr 2008 20:07:00 -0500, Dave Peterson
wrote:

Nope--not on xl2007.

Minitman wrote:

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

On Mon, 14 Apr 2008 18:52:49 -0500, Dave Peterson
wrote:

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

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