Split full names into first and last
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
Use formulas in A2:B5 to split each full name into first and last name.
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.5A2=IFERROR(LEFT(C2, FIND(" ", C2) - 1), C2)
| 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 |
Pass criteria
All must be met, checked automatically.A2:B5hold the expected values, from formulas
Passed 21
Autosheet in Excel Opus 5.5 · Medium
A2=IFERROR(LEFT(C2, FIND(" ", C2) - 1), C2)
| 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 |
Autosheet in Excel GPT-6 Astra · Low
A2=LEFT(C2,FIND(" ",C2)-1)
| 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 |
Autosheet in Sheets Opus 5.5 · Medium
A2=LEFT(C2, FIND(" ", C2) - 1)
| 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 |
Autosheet in Excel Sonnet 5.5 · Medium
A2=LEFT(C2,FIND(" ",C2&" ")-1)
| 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 |
Claude in Excel Opus 5.5 · High
A2=LEFT(TRIM(C2),FIND(" ",TRIM(C2))-1)
| 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 |
Autosheet in Excel Haiku 5.5 · High
A2=LEFT(C2,FIND(" ",C2)-1)
| 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 |
Claude in Sheets Opus 5.5 · Medium
A2=LEFT(TRIM(C2),FIND(" ",TRIM(C2))-1)
| 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 |
Claude Code + Sheets MCP Opus 5.5 · Medium
A2=LEFT(TRIM(C2),FIND(" ",TRIM(C2))-1)
| 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 |
Autosheet in Excel GPT-6.1 Sol · Medium
A2=LEFT(C2,FIND(" ",C2&" ")-1)
| 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 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
A2=IFERROR(__xludf.DUMMYFUNCTION("REGEXEXTRACT(TRIM(C2), ""^\S+"")"),"Ana")
| 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 |
ChatGPT + Autosheet MCP GPT-6 · Medium
A2=LEFT(C2, FIND(" ", C2) - 1)
| 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 |
Autosheet in Sheets Haiku 5.5 · High
A2=LEFT(C2, FIND(" ", C2) - 1)
| 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 |
ChatGPT in Excel GPT-6 Astra · Medium
A2=LEFT(C2,FIND(" ",C2)-1)
| 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 |
Claude in Sheets Haiku 5.5 · High
A2=LEFT(C2,FIND(" ",C2)-1)
| 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 |
Autosheet in Excel GPT-6 Luna · High
A2=TEXTBEFORE(C2," ")
| 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 |
Copilot in Excel Auto
A2=TEXTBEFORE(C2," ")
| 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 |
ChatGPT + Drive MCP GPT-6 · Medium
A2=IFERROR(__xludf.DUMMYFUNCTION("IF(TRIM(C2)="""","""",REGEXEXTRACT(TRIM(C2),""^\S+""))"),"Ana")
| 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 |
ChatGPT in Excel GPT-6 Luna · High
A2=LEFT(C2,FIND(" ",C2)-1)
| 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 |
Gemini in Sheets Auto
A2=LEFT(C2, FIND(" ", C2) - 1)
| 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 |
ChatGPT in Sheets GPT-6 Astra · Medium
A2=LEFT(TRIM(C2),FIND(" ",TRIM(C2)&" ")-1)
| 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 |
ChatGPT in Sheets GPT-6 Luna · High
A2=LEFT(C2,FIND(" ",C2)-1)
| 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 |
Failed 1
Claude in Excel Haiku 5.5 · High
| 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 |
Why it failed: A2:B5 hold no formula.