Home |
Search |
Today's Posts |
#1
|
|||
|
|||
city, state, zip from a single cell to multiple cells
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. |
#2
|
|||
|
|||
have a look at selecting the columndatatext to columns
-- Don Guillett SalesAid Software "wjs2002" wrote in message ... 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. |
#3
|
|||
|
|||
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 "wjs2002" wrote in message ... 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. |
#4
|
|||
|
|||
Looks like we are doing someone's homework. This is the second post with
the exact same question. :) "wjs2002" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple lines in 1 cell | Excel Discussion (Misc queries) | |||
Double-Clicking a cell for Multiple Options | Excel Discussion (Misc queries) | |||
counting Multiple answers in 1 cell + column | Excel Discussion (Misc queries) | |||
Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |