Fonts & Line Feed in a Cell
 

Is it possible to have multiple fonts within a single cell?

Also, is there a way to force a line feed when "copying" information from
multiple cells to a single cell?

Thanks MUCH!

Fonts & Line Feed in a Cell
 

€žMark B€� ezt Ã*rta:

Is it possible to have multiple fonts within a single cell?
Select the cell and in the formula bar select the text you want to format,
then set font format as required!


Also, is there a way to force a line feed when "copying" information from
multiple cells to a single cell?
You can concatenate two cells into a third one with formula =A1&B1
and can force a line feed between them with =A1&char(10)&B1 if you format
the result cell with wrapping.


Regards,
Stefi


Thanks MUCH!

Fonts & Line Feed in a Cell
 

Interestiung Stefi, Thanks, but now here is the last question, which I wasn't
anticipating. How can I make them both happen at the same time?

eg. When I use the =A1&char(10)&B1 formula, it does not preserve the font
that is in cell A1 in the new cell.

Thanks!



€žMark B€� ezt Ã*rta:

Is it possible to have multiple fonts within a single cell?
Select the cell and in the formula bar select the text you want to format,
then set font format as required!


Also, is there a way to force a line feed when "copying" information from
multiple cells to a single cell?
You can concatenate two cells into a third one with formula =A1&B1
and can force a line feed between them with =A1&char(10)&B1 if you format
the result cell with wrapping.


Regards,
Stefi


Thanks MUCH!

Fonts & Line Feed in a Cell
 

You can't unless you write a little macro for it. Otherwise you have to take
one more step: Pastespecial Format or use Format painter!

Regards,
Stefi

€žMark B€� ezt Ã*rta:

Interestiung Stefi, Thanks, but now here is the last question, which I wasn't
anticipating. How can I make them both happen at the same time?




eg. When I use the =A1&char(10)&B1 formula, it does not preserve the font
that is in cell A1 in the new cell.

Thanks!



€žMark B€� ezt Ã*rta:

Is it possible to have multiple fonts within a single cell?
Select the cell and in the formula bar select the text you want to format,
then set font format as required!


Also, is there a way to force a line feed when "copying" information from
multiple cells to a single cell?
You can concatenate two cells into a third one with formula =A1&B1
and can force a line feed between them with =A1&char(10)&B1 if you format
the result cell with wrapping.


Regards,
Stefi


Thanks MUCH!

Fonts & Line Feed in a Cell
 

Mark

A cell with a formula cannot have different font sizes and colors.

You must first change to a value by copypaste specialvaluesokesc

Now F2 to edit the contents.


Gord Dibben MS Excel MVP

On Thu, 8 Feb 2007 06:29:01 -0800, Mark B
wrote:

Interestiung Stefi, Thanks, but now here is the last question, which I wasn't
anticipating. How can I make them both happen at the same time?

eg. When I use the =A1&char(10)&B1 formula, it does not preserve the font
that is in cell A1 in the new cell.

Thanks!



„Mark B” ezt írta:

Is it possible to have multiple fonts within a single cell?
Select the cell and in the formula bar select the text you want to format,
then set font format as required!


Also, is there a way to force a line feed when "copying" information from
multiple cells to a single cell?
You can concatenate two cells into a third one with formula =A1&B1
and can force a line feed between them with =A1&char(10)&B1 if you format
the result cell with wrapping.


Regards,
Stefi


Thanks MUCH!