First you need to turn on word wrap under formatcellsalignment, then use
CHAR(10), i.e.
="text"&CHAR(10)&"text2"
Regards,
Peo Sjoblom
"TX_KniveS" wrote:
I'm trying to insert a line feed (or carriage return) into a text formula I
have in a cell. I'm trying to concatenate text entered into two other cells
in this new cell and have the two entries on a different line within the same
cell. Anybody know how to do this?
|