Hi Everyone,
I am new to the site and very happy to be here. Thanks in advance for your help.
I am looking to clean up two lists I have that both have the same problem. The first list is emails and the second is phone numbers and I need to remove the date in parenthesis that comes after them.
Example:
emailaddresshotmail(1/1/2023)
emailaddressgmail(5/6/2010)
etc......
555-555-5555(10/5/2020)
917-555-1234(12/12/2012)
etc......
Each list is in the thousands, so I need to clean it up with a formula or code but i do not know how.
Any help is greatly appreciated.
Thanks, Matt
Bookmarks