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

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.
 
C

CLR

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
 
K

Karl Burrows

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

Formula to Separate City, State, Zip 6
city, state, zip in same cell 2
address1, address2, city, state, zip in one cell; need in 5 cells 4
parseing out City, State ?? 3
City State Zip 3
MERGE 6 cells/Columns into 1 3
Text to column using multiple spaces?? CITY STATE ZIP 2
How to change address, city, state zip code into separate columns 2

Top