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