Zip + Four Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet being used to merge addresses into letters and labels. The column containing the zip codes are all either five-digit or five-digit+four with no dashes to separate the five and four digits. Can someone please tell me how to insert this command into the spreadsheet so that the zip-codes come out correctly

I tried the help function, but it didn't work at all. I selected the column and selected format, cells, number, category and selected special - which had the 99999-9999 feature. I also tried using the custom feature, adding the suggested [<=99999]00000;00000-0000. None of that worked. I'd appreciate your input. thanks.
 
One solution using formulas is to add another column. Enter thi
formula and copy down (this assumes column A is the zipcode column)

=IF(LEN(A1)=9,LEFT(A1,5)&"-"&RIGHT(A1,4),A1)

This should show 9 digit zipcodes in #####-#### format and anythin
else (eg. 5 digit) as is
 
Back
Top