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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I format zip code (9) to use in Word merg doc 1
How can I get excel to mail merge zip codes plus 4 correctly? 1
Zip Code Last 4 Digit as Zero 1
Zip Code Macro 1
ZIP CODES 2
Zip code sort is an Excel problem even when using the special cat. 2
Format>Cells>Special>Zip Code 5
Leading zero from Zip Code not print on Label Merge 6

Back
Top