city, state, zip from a single cell to multiple cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been given a spreadsheet with city, state and zip all in the same
cell. Is there a way to split the city, state and zip into three seperate
cells? I have a large data base and do not want to do each one at a time.
 
Don has given you a good way with the "TextToColumns" feature, and if it
works with your data, it's the best way.........but, it don't always work
with every data instance.........if your data requires, the separation might
also be done with formulas..........but we would need a representative
sample of a few lines of data to decipher your specific formatting.

Vaya con Dios,
Chuck, CABGx3
 
Looks like we are doing someone's homework. This is the second post with
the exact same question. :)

I have been given a spreadsheet with city, state and zip all in the same
cell. Is there a way to split the city, state and zip into three seperate
cells? I have a large data base and do not want to do each one at a time.
 

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

city, state, zip in same cell 2
Formula to Separate City, State, Zip 6
address1, address2, city, state, zip in one cell; need in 5 cells 4
Line Breaks in cells - Mac OS X Leopard 1
parseing out City, State ?? 3
remove comma and text past it in cell 2
City State Zip 3
Un-Concatenate 3

Back
Top