Use a Carriage Returns when typing data into a text cell

[Far Farley]

What is the code for entering a carriage return in a text cell.? I
tried & char(10) &, but it didn't work.

What I want is to type

Far[the_char_return_code]Farley

resultng in

Far
Farley



** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software! Free Support at
http://www.ozgrid.com/forum/ **

 

[Frank Kabel]

Hi
char(109 is correct. You have to format the cell with word wrap in
addition ('Format - Cells - Alignment')