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.
Bookmarks