Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

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
0
Rowby Goren
Asked:
Rowby Goren
  • 5
  • 2
3 Solutions
 
John-Charles-HerzbergCommented:
This is the formula you need.

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

Thanks
JC
0
 
Rowby GorenAuthor Commented:
Thanks John and JC

For the informative link and the formula.

Rowby
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now