Microsoft Office Forums - View Single Post - Extract Numbers from Zip Code

Thread: Extract Numbers from Zip Code

View Single Post

Old

09-20-2011, 06:29 AM

Karen615

Karen615 is offline

Karen615 uses Windows 7 64bit

Windows 7 64bit Karen615 uses Office 2010 64bit

Karen615 uses Office 2010 64bit

Office 2010 64bit

Competent Performer

The original poster

Join Date: Jun 2011

Location: Chicago

Posts: 145

Karen615 is on a distinguished road

Talking

Extract Numbers from Zip Code

I have a column of zip codes
Ex: 12345-0000

I want to extract only the six-digit zip code and eliminate the additional 4-digit extension. How can this be done?
Your help is greatly appreciated.
Thank you, Karen

Reply With Quote