# How to extract name from email address in Excel

If want to extract the name part of an email address, you can do so with a formula that uses the LEFT and FIND functions. In the formula below, email represents the email address you are working with.

## Formula

=LEFT(email,FIND("@",email)-1)

## Explanation

In the example, we are using this formula:

=LEFT(C4,FIND("@",C4)-1)

### Here’s how the formula works:

At the core, this formula is extracting characters starting from the left, and using the FIND function to figure out how many characters to extract.

First, FIND looks for the “@” character inside the email address “achang@maaker.com”. The “@” character is the 7th character so FIND returns 7. The number 1 is then subtracted from 7 to yield 6. This is done to prevent the formula from extracting the “@” along with the name. The LEFT function then extracts 6 characters from the email address, starting from the left. So:

=LEFT(C4,FIND("@",C4)-1) =LEFT("achang@maaker.com",FIND("@","achang@maaker.com")-1) =LEFT("achang@maaker.com",7-1) =LEFT("achang@maaker.com",6) ="achang"