question

M

mark

I am trying to work with a database of names and adresses.
Currently the customers information is in one colum. Is
it possible to move it into a row so names are contained
in one collom business name in another, street address
another, and city, state and zip another.
 
P

Paul Corrado

If they are separated by commas or some delimiter other than a space, then
yes.

For example

John Doe, 123 Main St., Anywhere, ND, 12345

However

If you only have a space as the delimiter, then Data|Text to Columns will
put each word in a separate cell, and that would be a mess.

PC
 
Top