pulling out info. seperated by a comma

  • Thread starter Thread starter scrabtree
  • Start date Start date
S

scrabtree

I have an address in one cell. I would like to seperate
the address into multiple cells at the point of each
comma. This way, for example, the state, and the city
would be in two cells instead of one.?????
 
Select the column and do Data=>Text to Columns and select the comma as the
delimiter.
 
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

How to remove duplicate text with comma seperated 5
Thousand/Decimal seperator 3
Check if text box has more than one entry seperated by a comma 2
How seperate text with comma in a cell into seperate rows 3
Splitting cells 5
Import a comma delimited file & match records 3
comma seperated values using multiple vlookup 2
Commas appear when typing 1

Back
Top