How do I convert zip+4 to 5-digit zip?

G

Guest

I have a spreadsheet with a column that has a mixture of zip+4 and five-digit
zip. How do I quickly make the entire column just five-digit zip?
 

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

mixing zip with zip+4 and then sorting 2
Excel and zip codes 10
More zip + 4 problems 1
Excel 2007 is stupid dealing with zipcodes 2
How to merge Excel address columns when some zips begin with zeros 4
Turning a 9 digit string into zip+4 3
look up zip code 4
only 5 digit zip codes 1

Top