austinandreikurt
Board Regular
- Joined
- Aug 25, 2020
- Messages
- 91
- Office Version
- 2016
- Platform
- Windows
Hi,
How do I split phone and email address merge in a cell? Below are the examples and the needed results:
Thank you in advance!
How do I split phone and email address merge in a cell? Below are the examples and the needed results:
- There are instances where there is no phone or no email or there is 2 or more emails.
- The phone is always one time only if there is and the result should replace characters () and -
- The email is always with "@" and there might be 2 or more emails, the result should have a separator ;
- There are extra spaces to be eliminated with TRIM/CLEAN
Phone / Email | REMARKS | Phone Result | Email Result |
(925) 474-1000 abcdefghij@yahoo.org | Usual sample | 9254741000 | abcdefghij@yahoo.org |
(925) 828-1000 a2z@google.com | Usual sample | 9258281000 | a2z@google.com |
yesyes@outlook.org | Email Only | yesyes@outlook.org | |
(925) 828-1000 a2z@google.com abcdefghij@yahoo.org | 2 emails | 9258281000 | a2z@google.com; abcdefghij@yahoo.org |
(925) 800-1000 hithere@yahoo.com | Usual sample | 9258001000 | hithere@yahoo.com |
Thank you in advance!