Get name from email address

An excel formula to get name from email address

Related Functions

Sponsored Link

 Get name from email address
=LEFT(email,FIND("@",email)-1)

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 generic form above, email represents the email address you are working with.

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 "[email protected]". 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:

  

 

Sponsored Link

0 votes. 0 / 5