Luke

if every address is in 5 lines than you can do the following:

A B C D E F
1 1 Luke Road =B3 =B4 =B5 =B6
2 Luke Town
3 Luke City
4 Lukeshire
5 LU1 1KE
than select C1:F5, drag (by the little cross hair + that form at the bottom
right corner of the last selected cell) till the end of your data. now C to F
will have data opposite the first line of the address. paste special and then
you can filter out the blank cells (C to F) and delete the rows. you have
your data




"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