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.
Bookmarks