If they all have a comma separating Town, State, and zip you could use
the Text to Columns under Data to separate the data into 3 columns. Then
use =A1&","&B1 to put the town and state back together in one column.

Bob

Zip Codes wrote:
I have about 900 cells and all of them appear in the following way
A
Town, State, 99999
Town1, State1, 11111

I need to have the zip code (99999 in the example) in one column, and then
town and state in another column so it would look like this
A B
Town, State 99999
Town 1, State 1 11111

I've been experimenting with the RIGHT and LEFT formula-- =RIGHT (A1, 5)
which would give me the zip code. The problem is i can only do this for
individual cells so i would have to do A1, A2, A3 and so on. Is there a way
to write a macro or formula to get all of the cells to transfer over without
having to type A1 over and over?