# How to create email addresses from first and last names in Excel

Join the names with a period, remove spaces and apostrophes, lowercase it and add the domain: =LOWER(SUBSTITUTE(SUBSTITUTE(A2&"."&B2," ",""),"'",""))&"@"&$F$1.

**Excel:** `=LOWER(SUBSTITUTE(SUBSTITUTE(A2&"."&B2," ",""),"'",""))&"@"&$F$1` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D | E | F |
| --- | --- | --- | --- | --- | --- |
| First | Last | Email |  | Domain | northwind.example |
| Maria | Lopez |  |  |  |  |
| James | O'Neil |  |  |  |  |
| Mary Ann | Smith |  |  |  |  |
| Lars | Eriksen |  |  |  |  |
| Chidi | Okafor |  |  |  |  |
| Aiko | Tanaka |  |  |  |  |

Formula in C2, filled to C7: `=LOWER(SUBSTITUTE(SUBSTITUTE(A2&"."&B2," ",""),"'",""))&"@"&$F$1`

Result: maria.lopez@northwind.example; james.oneil@northwind.example; maryann.smith@northwind.example; lars.eriksen@northwind.example; chidi.okafor@northwind.example; aiko.tanaka@northwind.example

## How it works

`A2&"."&B2` builds "Mary Ann.Smith". The inner SUBSTITUTE removes the space in "Mary Ann", the outer one removes the apostrophe in "O'Neil", and LOWER makes it all lowercase. The domain comes from `$F$1`, locked so every row uses it.

## Other ways

- `=LOWER(A2&"."&B2&"@"&$F$1)`: The short version, fine when no name has spaces or punctuation. (Keeps the space and the apostrophe: "mary ann.smith@…" and "james.o'neil@…".)
- `=LOWER(LEFT(A2,1)&SUBSTITUTE(B2,"'",""))&"@"&$F$1`: First initial plus last name, the other common company pattern. (mlopez@northwind.example instead of maria.lopez@northwind.example.)

## Common mistakes

- Two people with the same name get the same address. Check the new column with `=COUNTIF($C$2:$C$7,C2)>1`.
- Accented letters (é, ñ) stay in the address. Replace them with SUBSTITUTE if your mail system doesn't accept them.

## Questions

**How do I do it from a full name in one cell?**

Replace the space with a period: `=LOWER(SUBSTITUTE(A2," ","."))&"@"&$F$1`.

**How do I make the addresses clickable?**

Wrap the result in HYPERLINK: `=HYPERLINK("mailto:"&C2,C2)`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/create-email-address-from-name