Thread: City State Zip
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Texas Nuckols Texas Nuckols is offline
external usenet poster
 
Posts: 10
Default City State Zip

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