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.
The data can be numbers or text.
I would like the result to be as follows.