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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re-organizing list information into filterable table 1
Un-Concatenate 3
Excel 2
Database sorting 1
Excel xp question 5
moving cell contents (automatically) 2
Move rows into columns 3
How can I add a character to the end of every row in Excel 2000? 6

Back
Top