Manu

Assuming the column in question is Column A, enter in cell B1 =Left(A1,5)
and copy cell B1 down column B.
Then format Column B as text.
Then Copy/PasteValues Column B

--
XL2002
Regards

William



"Manu" wrote in message
...
| Column contains 10 characters (e.g. 02453-1234) making up the zip+4. I
need
| to remove the last 5 characters, leaving only the basic 5 digit zip-code.
| The column contains about 10,000 entries. Please suggest methods by which
| this can be done. Thanks!