question

  • Thread starter Thread starter mark
  • Start date Start date
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.
 
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
 
Back
Top