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

M

mniquette

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

Address Format changed after Migration 0
mixing zip with zip+4 and then sorting 2
Turning a 9 digit string into zip+4 3
REINSTALLING MS OFFICE PRO PLUS 2019 0
Excel 2007 is stupid dealing with zipcodes 2
How to merge Excel address columns when some zips begin with zeros 4
How to use matching values in two worksheets to return another value 5
Adding a HYPHEN to a 9 digit zip code column 7

Top