How to force text wrap or enter a linefeed?

[xcel_refugee]

The equivalent Excel command is alt-Enter. It's a very important capability yet I can't find reference to it anywhere.

Please advise how I can start a new line within a cell.

[Jossi]

In PlanMaker, it's Ctrl+Enter.

[@SonCook]

I have a mailing list with LNAME, FNAME, ADDR1, ADDR2, CITY, STATE, CODE all in one cell with each data item separated by a comma. I can force the text wrap after each item by typing CTL+Enter. Can I use SUBSTITUTE() change the commas into a 'Ctl+Enter' or '^p'? I want all the data in a single cell stacked on top of each other not run out on a single line. Doable?

[SuperTech]

Yes. You can replace each comma with a line break by entering the following formula in a temporary cell:

Code: Select all

=SUBSTITUTE(A1, ",", CHAR(10))

If each comma is followed by a space, use:

Code: Select all

=SUBSTITUTE(A1, ", ", CHAR(10))

The formula cannot change the contents of the source cell directly. After applying it to the required rows, copy the resulting cells and use Paste special | Values to paste the converted text into the desired cells. You can then delete the temporary formula column.