How can I remove the +4 from a zip. I have complete addresses in individual cells. If there exists a zip code with the +4 number, I want to remove the +4 and leave only the 5-digit code. Thanks
Current Cells
JOE SMITH 10-09-07 123 OAK DRIVE HOLLYWOOD CA 73099
JOE SMITH 10-09-07 123 OAK DRIVE HOLLYWOOD CA 73099-1234
ANY NAME MANHASSET NY 11030-6678
ANY NAME MANHASSET NY 11030
Expected Output
JOE SMITH 10-09-07 123 OAK DRIVE HOLLYWOOD CA 73099
JOE SMITH 10-09-07 123 OAK DRIVE HOLLYWOOD CA 73099
ANY NAME MANHASSET NY 11030
ANY NAME MANHASSET NY 11030
Bookmarks