Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When I use Text to Columns this separates fine until it gets to Oklahoma
City, Fort Smith, San Diego, Little Rock, etc. Then I get a separate column for City, Smith, Diego, Rock. Raw data had City State and Zip all separated by Spaces, no commas or tabs. The database is too long to do all of these manually. Please Help Soon??! Need this: Little Rock AR 72207 to be: |Little Rock|AR|72207| Not: |Little|Rock|AR|72207 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
separate an address street/city,state,zip within a cell? | Excel Worksheet Functions | |||
Compare City and State to Master List | Excel Worksheet Functions | |||
zip code to city, state function | Excel Worksheet Functions | |||
city, state, zip in same cell | Excel Discussion (Misc queries) | |||
Splitting City State Zip | Excel Worksheet Functions |