# Get name from email address

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:

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:

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.