View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Robert Judge
 
Posts: n/a
Default How do I convert 9 digit zipcodes to 5 digits?

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.