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
 
Rowby GorenConnect With a Mentor Author Commented:
Thanks John and JC

For the informative link and the formula.

Rowby
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
All Courses

From novice to tech pro — start learning today.