Thread: Split data from column

hi all need your help in following problem

i have data in different cells in column a as under , no limiter i can think of



Alsssssss Jonh M
(B) Worker
That place.
(H) 175, This Street 110.
Heresville AA 55555
123456


need all this data to be in different columns

a total of 3000 entries ,
some data do not have a home address


Your help will be greatly appreciated

Are there carriage returns possibly?

For example if that exact sample is in cell A1, then what does this formula return?

=CODE(MID(A1,17,1))

replace A1 with the address of cell containing the exact example above..... and hopefully that is not a real address for that person.... I will adjust it anyways... except length of the first line... where 17 is the number of characters from first character + 1 in first line only

As long as you have the name/address lists each with consistent number of lines and directly beneath each other, then, assuming you have them beginning in A1, try:

=INDEX($A:$A,6*(ROWS($A$1:$A1)-1)+COLUMNS($A$1:A$1))

copied across 6 columns and down as far as you need to retrieve all items.