Excel formula to create an email address from first and last name
In short: Choose a pattern (first.last, flast, first, firstl, last.first and six more), the name and domain cells or a fixed domain, and copy one formula that works in Excel and Google Sheets. Paste your rows to see the addresses it builds, with accents and apostrophes cleaned. Limit: It builds the text of an address in the pattern you pick. It can't know the company's real pattern or that the mailbox exists.
To create an email address from a first and last name in Excel, join the parts with &: =LOWER(A2&"."&B2&"@"&C2) gives [email protected] from Jane, Doe and example.com. Pick another pattern, such as flast or first, and the generator writes the formula for it. The same formula works in Google Sheets. It builds a guess, so verify the results.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. See pricing
Formula for Excel and Google Sheets
=IF(OR(A2="",B2="",C2=""),"",LOWER(SUBSTITUTE(A2," ","")&"."&SUBSTITUTE(B2," ","")&"@"&C2))
Put it in the first row's empty column and fill down. The domain column must hold a bare domain (example.com), not a website URL.
Sample result
Jane, Doe and example.com become [email protected].
- first.last
- [email protected]
- José O'Neil
- [email protected]
What this means for you
The formula builds a guess in the pattern you pick. Verify it before you send.
- 11 patterns: first.last, flast, first…
- One formula for Excel and Sheets
- Run on your rows, accents removed
- Blank when a name is missing
- Excel
- Formula
- Patterns
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
These are guesses until a mail server confirms them.
- Copy the column of built addresses, or use the button under the results.
- Upload or paste it at /verify. The first 100 email checks are free with a Google sign-in, no card.
- For every list after that, Pro includes unlimited email verification. Fair use: the first 100,000 checks a month at full speed, then slower, never cut off.
How do I create email addresses from names in Excel?
- Pick the pattern the company uses, such as first.last or flast. If you don't know it, find it with the email format finder first.
- Enter the cells with the first name and last name (A2 and B2) and either the domain cell (C2) or the domain itself.
- Copy the formula into the first row's empty column and fill it down.
- Or paste the name and domain columns here to get the addresses at once, with accents and apostrophes removed, then verify them.
Example
- You enter
- Pattern first.last, first name in A2, last name in B2, domain in C2; rows Jane Doe (https://www.example.com), José O'Neil (example.org), Mary Ann Lee (example.net), Tom with no last name.
- You get
- Formula
=IF(OR(A2="",B2="",C2=""),"",LOWER(SUBSTITUTE(A2," ","")&"."&SUBSTITUTE(B2," ","")&"@"&C2)). Built:[email protected],[email protected](the formula would givejosé.o'neil@),[email protected], and a blank for Tom. - Limits
- Runs in your browser with no row cap.
How do you combine first and last name into an email in Excel?
With the & operator, which joins text: A2&"."&B2&"@"&C2. Wrap it in LOWER so Jane becomes jane, and in SUBSTITUTE to drop spaces from names like Mary Ann. The generator adds an IF so a row with a missing name gives a blank instead of [email protected].
For patterns with an initial, LEFT(A2,1) takes the first letter. flast is LEFT(A2,1)&B2, firstl is A2&LEFT(B2,1). CONCAT and TEXTJOIN work too, but & is the one every Excel and Sheets version understands.
What do formulas get wrong with names?
Accents and apostrophes. José O'Neil becomes josé.o'neil@ in a formula, while the company's mail server almost certainly has jose.oneil@. Excel has no function to remove accents without a long chain of SUBSTITUTEs, so the tool's own run strips accents (é to e, ß to ss) and apostrophes and shows where its result differs from the formula's.
Double-barrelled names and nicknames vary by company: some keep the hyphen, some drop it, some use the first part only. That's why a built address is a guess.
How do I know which email pattern a company uses?
Look at an address you already have at that domain, or find it with the email format finder. If you have no address, build two or three patterns and verify them: the mailbox that the domain's server accepts is the one to use. On a catch-all domain every pattern is accepted, so the result stays a guess; the email permutator lists every pattern for each person.
Formula or this tool?
| Excel or Sheets formula | This tool's run | |
|---|---|---|
| Patterns | One per formula | One per run, 11 to choose from |
| Spaces in names | Removed with SUBSTITUTE | Removed |
| Accents and apostrophes | Kept (josé, o'neil) | Removed (jose, oneil) |
| Missing names | Blank, with the IF guard | Blank |
| Mailbox exists | Not known | Not known until you verify |
Who uses this tool, and for what?
- Recruiters
- Turn a sheet of candidate names and company domains into first.last guesses, then verify which ones the company's server accepts.
- SDRs
- Fill the email column of an event attendee list that came with names and companies only.
- IT admins
- Build the address column for new staff accounts in the company's pattern before a bulk import.
What can’t this tool tell you?
- It builds the text of an address in the pattern you pick. It can't know the company's real pattern or that the mailbox exists.
- Nicknames, middle names and hyphenated names follow each company's own rules, which no formula knows.
- The formula keeps accents and apostrophes; only the tool's own run removes them.
Common questions
- What is the formula for first initial last name email in Excel?
- =LOWER(LEFT(A2,1)&B2&"@"&C2), with the first name in A2, last name in B2 and domain in C2. It gives [email protected].
- How do I create an email address from first and last name in Google Sheets?
- The same formula works: =LOWER(A2&"."&B2&"@"&C2). Google Sheets supports & , LOWER, LEFT and SUBSTITUTE exactly as Excel does.
- How do I add @domain.com to names in Excel?
- Append it as text: =LOWER(A2&"@example.com"). Enter the domain in the generator instead of a cell and it writes that for you.
- Are the built email addresses real?
- Not necessarily. A formula only builds the text in the pattern you chose; verify the addresses to see which mailboxes exist.
Sources
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.