How do I convert 9 digit zipcodes to 5 digits?

[Guest]

I have an EXCEL 2003 spreadsheet containing a column with zip codes in this
format:
12345-6789

How can I convert these zip codes to a column that just has the first five
digits, that is:
12345

?

I will appreciate advice.

 

[Guest]

In the new column use the formula =LEFT(A1,5)

 

[Anne Troy]

=left(a1,5) will pull the first 5 characters from a cell.
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

 

[Gord Dibben]

Data>Text to Columns

De-limited by -

Choose to not import(skip) the second column.


Gord Dibben Excel MVP