Separate Zip Code from City, State Zip Code

[caunyd]

Through the kindness of forum member jhren, I was able to do almost everything I need to do through Excel. The last step is separating the Zip Code from City, State Zipcode. Here's the format that I'm using:

A________________B__________________C__________________D______________________E____________________F
Last Name________First Name__________empty column________street address___________City, State Zip Code____Zip Code (this is what I want to do).


Here is the actual file that I'm using (courtesy of an amalgam of Jhren's work). Thanks for your help!

[jeffreybrown]

Looks like this should work...

F2 >> =LEFT(E2,FIND(",",E2)-1)
G2 >> =MID(E2,FIND(",",E2)+2,2)
H2 >> =RIGHT(E2,5)

[AlKey]

1. This will give you the City name without Sate and Zip
=TRIM(LEFT(E2,LEN(E2)-10))
2. This will give you State
=MID(E2,FIND(",",E2)+2,2)
3. This will give ZIP
=RIGHT(E2,5)

[rollis13]

You will also need to unhide (and resize) many rows in your sheet.