View Single Post
  #4   Report Post  
TX_KniveS
 
Posts: n/a
Default

Thanks Peo, thats exactly what I needed.

"Peo Sjoblom" wrote:

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?