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.
--
David Biddulph

"Mike H" wrote in message
...
hi,

Select the column then try
Data|Text to columns and follow the wizard

Mike

"Naples" wrote:

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?