Fonts & Line Feed in a Cell

[Guest]

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!

 

[Guest]

„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

 

[Guest]

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!

 

[Guest]

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:

 

[Gord Dibben]

Mark

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

You must first change to a value by copy>paste special>values>ok>esc

Now F2 to edit the contents.


Gord Dibben MS Excel MVP