Pull out zip code in excel

I have Column K that has thousands of zip code. Some of the zip codes are just the 5 digits and some are the 5 digits then a dash and 4 more digits.

I need to have a column of just the 5 digits, not the "dash-four more". Any way I can either delete the dash info or simply pull out the first 5 digits? For example:

Column K
93706
93722-2451
84487-5474
92653
87415-5474

Thanks!
cansevinAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Giovanni HewardConnect With a Mentor Commented:
Create a new column and use the LEFT function.

A1 = 10001-1001
B2 = LEFT(A1,5)
0
 
BlueYonderCommented:
The formula is below.  Fill A1 with the specified cell.
=LEFT(K1, 5)
0
 
Saqib Husain, SyedEngineerCommented:
You can also use
Data > Text to columns > Delimited > Use the "-" character
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.