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:

name from email address

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.

name from email address

To do the same, we will begin by inputting the LEFT Function which is as follows:

=LEFT(

The following formula requires text as well as number characters.

name from email address

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.

name from email address

Then we will input the FIND Function which is as follows:

=FIND(

The following formula requires find text, within text, and start number.

name from email address

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.

Learn: Get number of hours between two times

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.

name from email address

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.

name from email address

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.

name from email address

After jotting down the same, we will close the LEFT Function as well. By this our overall formula becomes as follows:

=LEFT(C2,FIND(“@”,C2)-1)

name from email address

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 cheesecake@yumyum.com🤤 email address.

name from email address

It’s easy, isn’t it😉?