How to use mid or left functions to seperate city,st,zip with no commas

sinaranje · #1 11-10-2014, 08:40 PM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Suppress comma in "city , stat zip" line when blank	DHammer	Mail Merge	1	05-30-2014 02:43 AM
No inverted commas in word 2013.	tonycrossley	Word	3	01-27-2014 04:55 PM
mail merge treating CITY as DATE	woody	Mail Merge	6	01-30-2013 03:22 PM
Merge to Seperate Documents	joughin	Mail Merge	1	05-17-2012 05:08 PM
Seperate Column widths in one worksheet	miller.3276	Excel	2	01-27-2010 02:12 PM