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
LVL 9
Rowby GorenAsked:
Who is Participating?
 
John-Charles-HerzbergConnect With a Mentor Commented:
This is the formula you need.

=LEFT(A2, LEN(A2)-5)

Thanks
JC
0
 
John-Charles-HerzbergConnect With a Mentor Commented:
0
 
Rowby GorenConnect With a Mentor Author Commented:
Thanks John and JC

For the informative link and the formula.

Rowby
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Sign Up
 
Rowby GorenAuthor Commented:
Ooops I meant to split the points.  GIving 100 for the link and 400 for formula.

Can a Moderator help here?

Rowby
0
 
Rowby GorenAuthor Commented:
I left a request for the Moderator to fix the point split.

Rowby
0
 
Rowby GorenAuthor Commented:
OK WITH ME!  :)
0
 
Rowby GorenAuthor Commented:
Good.  Thanks to the Moderator for letting me correcting the point split.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Advertise Here