| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
parseing out City, State ??
I have a file like this
Name Address City State ZIP Zimmer 221 W 10 ATLANTA, GA 11111 So the CITY field contains both the City and a comma, state How can I easily go through my 5,000 records and move the State to the actual STATE field in excel? thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofill a city and state from a zipcode | New Users to Excel | |||
| City State Zip | Excel Discussion (Misc queries) | |||
| City State Zip | Excel Worksheet Functions | |||
| city, state, zip in same cell | Excel Discussion (Misc queries) | |||
| Splitting City State Zip | Excel Worksheet Functions | |||
Threaded Mode
