Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
You may try the following UDF (User Defined Function) to validate if a cell contains an email.
To implement the UDF, follow these steps...
1) Open your workbook.
2) Press Alt+F11 to open VB Editor
3) On VB Editor --> Insert --> Module
4) Paste the code given below into the opened code window.
5) Close the VB Editor
6) Save your workbook as Macro-Enabled Workbook.
Now you may use the function CheckForAnEmail like this.....
Assuming your string is in D2, then try this....
In F2
Open in new window
UDF:
Open in new window