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
Can a Moderator help here?
Rowby