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?