Extract domains from email addresses
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
Use formulas in E2:E5 to pull the domain from each email address.
Starting spreadsheet
People| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | ||
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | ||
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | ||
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 |
A passing output
Autosheet in Excel · Opus 5.5E2=MID(D2, FIND("@", D2) + 1, LEN(D2))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
Pass criteria
All must be met, checked automatically.E2:E5hold the expected values, from formulas
Passed 22
Autosheet in Excel Opus 5.5 · Medium
E2=MID(D2, FIND("@", D2) + 1, LEN(D2))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
Autosheet in Excel GPT-6 Astra · Low
E2=RIGHT(D2,LEN(D2)-FIND("@",D2))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
Autosheet in Sheets Opus 5.5 · Medium
E2=IF(D2="", "", MID(D2, FIND("@", D2) + 1, LEN(D2)))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
Autosheet in Excel Sonnet 5.5 · Medium
E2=MID(D2,FIND("@",D2)+1,LEN(D2))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
Claude in Excel Opus 5.5 · High
E2=MID(D2,FIND("@",D2)+1,LEN(D2))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
Autosheet in Excel Haiku 5.5 · High
E2=MID(D2,FIND("@",D2)+1,LEN(D2)-FIND("@",D2))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
Claude in Sheets Opus 5.5 · Medium
E2=MID(D2,FIND("@",D2)+1,LEN(D2))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
Claude Code + Sheets MCP Opus 5.5 · Medium
E2=IFERROR(LOWER(TRIM(MID(D2,FIND("@",D2)+1,LEN(D2)))),"")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
Autosheet in Excel GPT-6.1 Sol · Medium
E2=RIGHT(D2,LEN(D2)-FIND("@",D2))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
E2=IFERROR(__xludf.DUMMYFUNCTION("IFERROR(REGEXEXTRACT(D2, ""@(.+)$""), """")"),"example.com")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
ChatGPT + Autosheet MCP GPT-6 · Medium
E2=MID(D2, FIND("@", D2) + 1, LEN(D2))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
Autosheet in Sheets Haiku 5.5 · High
E2=RIGHT(D2, LEN(D2) - FIND("@", D2))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
ChatGPT in Excel GPT-6 Astra · Medium
E2=RIGHT(D2,LEN(D2)-FIND("@",D2))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
Claude in Excel Haiku 5.5 · High
E2=MID(D2,FIND("@",D2)+1,LEN(D2))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
Claude in Sheets Haiku 5.5 · High
E2=MID(D2,FIND("@",D2)+1,LEN(D2))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
Autosheet in Excel GPT-6 Luna · High
E2=MID(D2,FIND("@",D2)+1,LEN(D2))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
Copilot in Excel Auto
E2=RIGHT(D2,LEN(D2)-FIND("@",D2))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
ChatGPT + Drive MCP GPT-6 · Medium
E2=IFERROR(__xludf.DUMMYFUNCTION("IFERROR(REGEXEXTRACT(D2,""@(.+)$""),"""")"),"example.com")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
ChatGPT in Excel GPT-6 Luna · High
E2=TEXTAFTER(D2,"@")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
Gemini in Sheets Auto
E2=MID(D2, FIND("@", D2) + 1, LEN(D2))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
ChatGPT in Sheets GPT-6 Astra · Medium
E2=RIGHT(D2,LEN(D2)-FIND("@",D2))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |
ChatGPT in Sheets GPT-6 Luna · High
E2=MID(D2,FIND("@",D2)+1,LEN(D2))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | example.com | 42 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | contoso.fr | 381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | northwind.co.uk | 7 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | fabrikam.com | 9102 |