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: