split columen

N

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?
 
S

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...
 
D

David Biddulph

I don't think Mike's solution will work when the data is in a number of rows
in one column. It would be OK if trying to split once cell into separate
columns, particularly if the fields were separated by a delimiter such as
comma or tab.

Is the number of rows the same for each record? If so, an OFFSET formula
should do the trick.
 
Top