Hi all hope you can help

I have a weird import sheet that I need to use monthly and its important that I fix the zip code field. Currently a zip code comes in like this '10012 or '10012-4004

I need to clean the apostrophe out which is easy enough but if so do and some dont have the extra -4004 part (obviously the exact value can vary) how do I get the system to clean that part out also if it is there?


Any help much appreciated.