split columen
 

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?

split columen
 

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?

split columen
 

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

"Mike H" wrote:

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?

split columen
 

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?