All AutosheetBench tasks

Combine first and last names

FormulasEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

Use formulas in C2:C101 to combine each first and last name into a full name.

Starting spreadsheet

People · rows 1–21 of 101
ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

A passing output

Autosheet in Excel · Opus 5.5
People100 cells changed

C2=TRIM(A2&" "&B2)

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

How each AI configuration did

21 of 22 passRun files
Excel and Sheets · All types · All models · All outputs

Pass criteria

All must be met, checked automatically.
  • C2:C101 hold the expected values, from formulas

Passed 21

Autosheet in Excel Opus 5.5 · Medium

Passed9s · 2¢
People100 cells changed

C2=TRIM(A2&" "&B2)

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

Autosheet in Excel GPT-6 Astra · Low

Passed6s · 5¢
People100 cells changed

C2=A2&" "&B2

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

Autosheet in Sheets Opus 5.5 · Medium

Passed10s · 2¢
People100 cells changed

C2=TRIM(A2&" "&B2)

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

Autosheet in Excel Sonnet 5.5 · Medium

Passed5s · 1¢
People100 cells changed

C2=TRIM(A2&" "&B2)

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

Claude in Excel Opus 5.5 · High

Passed16s · 16¢
People100 cells changed

C2=TRIM(A2&" "&B2)

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

Autosheet in Excel Haiku 5.5 · High

Passed7s · 0.1¢
People100 cells changed

C2=TRIM(A2&" "&B2)

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

Claude in Sheets Opus 5.5 · Medium

Passed33s · 9¢
People100 cells changed

C2=TRIM(A2&" "&B2)

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed42s · N/A
People100 cells changed

C2=TRIM(A2&" "&B2)

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

Autosheet in Excel GPT-6.1 Sol · Medium

Passed10s · 2¢
People100 cells changed

C2=A2&" "&B2

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed30s · N/A
People100 cells changed

C2=TRIM(A2&" "&B2)

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed54s · N/A
People100 cells changed

C2=TRIM(TRIM(A2)&" "&TRIM(B2))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

Autosheet in Sheets Haiku 5.5 · High

Passed14s · 0.1¢
People100 cells changed

C2=TRIM(A2&" "&B2)

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

ChatGPT in Excel GPT-6 Astra · Medium

Passed18s · 36¢
People100 cells changed

C2=A2&" "&B2

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

Claude in Sheets Haiku 5.5 · High

Passed33s · 0.7¢
People100 cells changed

C2=TRIM(A2&" "&B2)

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

Autosheet in Excel GPT-6 Luna · High

Passed6s · 0.1¢
People100 cells changed

C2=People!A2&" "&People!B2

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

Copilot in Excel Auto

Passed21s · N/A
People100 cells changed

C2=TRIM(A2&" "&B2)

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

ChatGPT + Drive MCP GPT-6 · Medium

Passed39s · N/A
People100 cells changed

C2=TRIM(A2&" "&B2)

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

ChatGPT in Excel GPT-6 Luna · High

Passed17s · 0.4¢
People100 cells changed

C2=A2&" "&B2

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

Gemini in Sheets Auto

Passed40s · N/A
People100 cells changed

C2=A2&" "&B2

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

ChatGPT in Sheets GPT-6 Astra · Medium

Passed20s · 32¢
People100 cells changed

C2=A2&" "&B2

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

ChatGPT in Sheets GPT-6 Luna · High

Passed22s · 0.3¢
People100 cells changed

C2=A2&" "&B2

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

Failed 1

Claude in Excel Haiku 5.5 · High

Failed24s · 0.5¢
PeopleNo cell changedWrong value
ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102
6User006Test006User006 Test006…@example.com1006
7User007Test007User007 Test007…@example.com1007
8User008Test008User008 Test008…@example.com1008
9User009Test009User009 Test009…@example.com1009
10User010Test010User010 Test010…@example.com1010
11User011Test011User011 Test011…@example.com1011
12User012Test012User012 Test012…@example.com1012
13User013Test013User013 Test013…@example.com1013
14User014Test014User014 Test014…@example.com1014
15User015Test015User015 Test015…@example.com1015
16User016Test016User016 Test016…@example.com1016
17User017Test017User017 Test017…@example.com1017
18User018Test018User018 Test018…@example.com1018
19User019Test019User019 Test019…@example.com1019
20User020Test020User020 Test020…@example.com1020
21User021Test021User021 Test021…@example.com1021

Why it failed: C2:C101 hold no formula.