Newline in a cell

[StarrRider]

You can make the text of a cell occupy multiple lines by adding the text and entering Alt-Return and then adding more text.

The question is - what character is actually added when the Alt-Return is entered?

I want to use it in a formula like
=CONCATENATE($J3," ",$K3) - and replace the " " with that character.

Thanks
Lee

 

[joerd]

That is CHAR(10) which is a line feed, as far as I recall. It seems you have to format the cell with Wrap Text, however, to make it work properly.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[StarrRider]

Thanks Jeord
Lee