Thank you all for earlier help. I am now parsing a column of 15,427
records containing combined State and Zip Code data, IE:

A
1 NY 10023

And I need to parse that data into two separate columns.

I was using the Macro funtion earlier for some successful endeavors,
but the tiny Macro Toolbar "Stop Recording / Reference" has
disappeared.

1) Can anyone help me with the trick to that bloody toolbar, and
2) Is a Macro the best way to accomplish such a parsing...

(With one empty new column to the right, I was going to go into cell
edit mode, Cut the Zip, delete the three spaces to the R of the State,
Paste the Zip in the new Column to the right, and decend one Row... or
something to that effect).

Thank you so much, folks.


--
jawdawson
------------------------------------------------------------------------
jawdawson's Profile: http://www.excelforum.com/member.php...o&userid=30648
View this thread: http://www.excelforum.com/showthread...hreadid=503121