About this exercise
A 100-row dataset on one sheet, one answer cell, about 4 minutes. Graded in your browser: the value and the formula behind it, with feedback that names the fix.
How to solve it
- D2
=B2&" "&C2
Joining text is called concatenation: the & operator (or the CONCAT function) returns the pieces written one after another, so =B2&" "&C2 yields the first name, then a space, then the last name. The space has to be a text literal in quotation marks — without it the names run together as one word. Because B2 and C2 are relative references, filling the formula down shifts them to B3/C3, B4/C4 and so on, producing all 100 full names from one formula.
Pitfall 1: =B2&C2 looks almost right and gives "GabrielFlores" — a missing separator is the most common concatenation error, and it is invisible until someone reads the badge. Pitfall 2: concatenating a number or a date converts it to plain text and drops its formatting (a start date becomes 46205); wrap such values in TEXT(F2,"yyyy-mm-dd") first. Pitfall 3: stray spaces in the source ("Olivia " with a trailing blank) survive concatenation and produce double spaces — clean the inputs with TRIM when the export is dirty. CONCAT (Excel 2019 and 365) replaces CONCATENATE and additionally accepts ranges (=CONCAT(B2:C2) joins both cells with no separator); CONCATENATE still works everywhere for compatibility. TEXTJOIN(" ",TRUE,B2:C2) is the range-friendly form with a delimiter and skips empty cells — useful when a middle-name column is often blank. For "Last, First" sorting lists, swap the order: =C2&", "&B2.
Other ways that work
- =CONCAT(B2," ",C2) — the function form (Excel 2019 and 365)
- =CONCATENATE(B2," ",C2) — legacy function, works in every version
- =TEXTJOIN(" ",TRUE,B2:C2) — delimiter once, skips blanks (Excel 2019 and 365)
Common mistakes
Leaving out the space: =B2&C2 returns "GabrielFlores". The separator must be its own text piece, " ", between the two references.
How we grade
Any formula that produces the right result is accepted, unless the task names a function: then another function earns half credit. We compare values with a small tolerance and ignore case and spaces in text. A correct number typed by hand instead of a formula earns half credit. Multi-cell tasks earn full credit at 100% of cells, half credit from 50%. Where it matters, we also change an input cell on a copy of your sheet and check that your formula follows.
Answers computed with Excel 365 rules and checked in our grading engine on November 16, 2026. Author: GridBelt team.