How about using DataText to ColumnsDelimited by space?


Gord Dibben MS Excel MVP

On Thu, 19 Jan 2006 17:07:30 -0600, jawdawson
wrote:


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.