If you use Data, Text to columns
be sure to specify within the Text to columns
that the second column is text. Formatting the
column as text beforehand is not good enough.

Many east coast zip codes have a leading zero.
---


"Gord Dibben" <gorddibbATshawDOTca wrote ...
How about using DataText to ColumnsDelimited by space?


Gord Dibben MS Excel MVP

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

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