Use Text to Columns with a tiny trick to specify the ALT-ENTER character:

1. click on the column
2. Data Text to columns... delimited Next Other and click in the
character entry box
3. while holding down the ALT key, touch 010 on the numeric keypad.
4. Finish

ALT-010 allows you to specify the hard-return as the separator.
--
Gary''s Student - gsnu200909


"LukeLibrarian" wrote:

Hello,

I have a column of over 600 addresses, and they are entered as follows:

1 Luke Road
Luke Town
Luke City
Lukeshire
LU1 1KE

When unwrapped, it obviously just looks like one long sentence with squares
where the (ALT+Enter)'s were.

My issue is that I would like to split each line of the address out into
adjacent columns. Any help would be gratefully received, and save me a few
hours of manually typing in commas so that I can TTC it!

--
Thanks
Luke