split columen

[Naples]

I have the following datas in ONE columne

first name
last name
address
city
etc...

and would like to split this in severals columns so I get a address DB. Any
help?

 

[Sean Timmons]

You can copy the rows, then go to a new row paste special, transpose, but
that depends on having only a few records. It's get awfully tiring after a
while. A macro would be best if you know how to do VB programming...