Thread: [Solved] How to use mid or left functions to seperate city,st,zip with no commas
View Single Post
 
Old 11-10-2014, 08:40 PM
sinaranje sinaranje is offline Windows 7 64bit Office 2003
Banned
  
Join Date: Nov 2014
Location: GB
Posts: 1
sinaranje is on a distinguished road
Default How to use mid or left functions to seperate city,st,zip with no commas
Hi all,

I have a list of approx. 2000 address that are in the following format

|Address 2|

Los Angeles CA 90210
Miami FL 20200
Bethesda MD 20817

My desired format:

City| State | Zip

Los Angeles CA 90210

All of these addresses have no commas to appropriately separate the city from the state or zip. Therefore using a mid function to pull out CITY, STATE, ZIP is difficult.

Does anyone have some ideas on how to segregate them? Thanks.
Attached Files
File Type: xlsx example for forum 1.xlsx (11.4 KB, 11 views)
Reply With Quote