Newline in a cell
Newline in a cell
(OP)
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
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





RE: Newline in a cell
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Newline in a cell
Lee