Avatar of Rowby Goren
Rowby Goren
Flag for United States of America asked on

Excel Converting Zip plus 4 to just 5 number zip

Hi

Using Excel 2007

I have a column of zip codes that are zip plus 4.  I need a formula that will change it to just the regular zip.

Zip Code
93309-2156
93932-0446
92509-3600
93711-5770

Open in new window


The data can be numbers or text.  

I would like the result to be as follows.

Open in new window

Zip Code
93309
93932
92509

Open in new window


Thanks!

Rowby
Microsoft Excel

Avatar of undefined
Last Comment
Rowby Goren

8/22/2022 - Mon
SOLUTION
John-Charles-Herzberg

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
John-Charles-Herzberg

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Rowby Goren

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Rowby Goren

ASKER
Ooops I meant to split the points.  GIving 100 for the link and 400 for formula.

Can a Moderator help here?

Rowby
Rowby Goren

ASKER
I left a request for the Moderator to fix the point split.

Rowby
Rowby Goren

ASKER
OK WITH ME!  :)
Your help has saved me hundreds of hours of internet surfing.
fblack61
Rowby Goren

ASKER
Good.  Thanks to the Moderator for letting me correcting the point split.