If you want to find out the name from an email address, you have walked into the right place😏. To find the same, all you need is the LEFT Function and FIND Function.
Let’s take an example for the same:
As you can see in the image above, we have a bunch h of email addresses and we are looking forward to find the email name from the same.
To do the same, we will begin by inputting the LEFT Function which is as follows:
The following formula requires text as well as number characters.
As we are looking for the name from the email address we have in hand, so the text becomes the email address, i.e. cell C2 in the above case.
Then we will input the FIND Function which is as follows:
The following formula requires find text, within text, and start number.
The find text will be the @ sign, we need to write the same under the quotation marks as shown in the image above. This is being done because @ sign is the one which is separating the domain name and the email name in the email address.
And quotation marks are necessary as we are adding specifications in the formula, if you will ignore the quotation marks then you wont get the answer either.
Then comes the case of with in text, as we are finding the @ sign inside the email address, so our within text becomes the email itself which is cell C2.
As start number is optional, so you can ignore the same and close the FIND Function, after closing the same, we continue in the number characters only, so here we will jot down -1. As we want to find out the email name, that is the left side of the @ sign we will use -1.
After jotting down the same, we will close the LEFT Function as well. By this our overall formula becomes as follows:
Now we will press enter, and simply drag down the formula to the extent it is required.
Here you go, your email name is cheesecake out of the email@example.com🤤 email address.
It’s easy, isn’t it😉?