Thread: How do I convert 9 digit zipcodes to 5 digits?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default How do I convert 9 digit zipcodes to 5 digits?
In the new column use the formula =LEFT(A1,5)

"Robert Judge" wrote:

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.
Reply With QuoteReply With Quote