Altering results returned in case of an error.

Problem:

Column A contains E-mail addresses, from which we would like to pull out the user names of Gmail users only (addresses containing ""@gmail"").
In case the address does belong to a gmail user, a string indicating that conclusion should be returned (instead of a #VALUE! Error).
Solution:

"Use the LEFT and FIND functions to find the requested substring in the address,
and the ISNUMBER and IF functions to determine the value to return in case the substring could not be found.
Following is the formula:
=IF(ISNUMBER(FIND(""@gmail"",A2)),LEFT(A2,FIND(""@gmail"",A2)-1),""Not a Gmail user"")

Example:

Emails_______________Gmail Users
User1@gmail.com______User1
User2@hotmail.com____Not a Gmail user
User3@yahoo.com______Not a Gmail user
User4@gmail.com______User4

Screenshot // Altering results returned in case of an error.
Altering results returned in case of an error.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.