Sharid
Well-known Member
- Joined
- Apr 22, 2007
- Messages
- 1,064
- Office Version
- 2016
- Platform
- Windows
I have a list of staff and suppliers in column F the problem is that for most the phone number and email is in the same cell, I want to clear all the phone numbers, Fax number or numbers, But NOT the numbers in the email. Phone/fax numbers vary is lenght. Im sure it can be done with vba but can not work it out
FROM | TO |
John.Smith@Gmail.comEmail: 01411112344Phone: | John.Smith@Gmail.comEmail: |
John1.Smith@Gmail.com: 01211112344Phone: 034567853Fax: | John1.Smith@Gmail.com: |
01311112344 |