Skip to content
GridBelt
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign in
Start the free test
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign inCreate account
Start the free test
GridBelt

Practice Excel in your browser.

Excel Test

  • Level 1: Beginner
  • Level 2: Intermediate
  • Level 3: Expert
  • Excel test in 7 days
  • Leaderboard
  • Excel test for interview
  • Indeed Excel assessment

Practice

  • All exercises
  • Programs
  • For beginners

Guides

  • Excel formulas
  • Excel shortcuts

Company

  • About
  • Pricing
  • How we grade

© GridBelt. All rights reserved.

  • Privacy Policy
  • Terms of Use
  • Refund Policy

Excel is a trademark of Microsoft Corporation. Indeed, TestGorilla, SHL and other marks are the property of their owners. GridBelt is an independent practice site and is not affiliated with, endorsed by or sponsored by Microsoft, TestGorilla, SHL or Indeed.

  1. Practice
  2. /
  3. Text functions

CONCAT practice: build 100 full names from two columns

  • Beginner
  • ~4 min
  • Text functions

The HR system exports 100 employees with the first name and the last name in separate columns (B and C), but the badge printer and the e-mail signature template both need one "Full name" field. 14 of the names are hyphenated, carry an apostrophe or an accent — they must come through unchanged. Build the full name in D2 with a single formula and fill it down to D101.

What you need to do

  1. 1Click D2 and type =B2&" "&C2 — the quotation marks hold the single space that separates the two names. Press Enter; D2 should read Gabriel Flores.
  2. 2Alternatively use the function form: =CONCAT(B2," ",C2) (CONCATENATE in older versions works the same way).
  3. 3Fill D2 down to D101: double-click the fill handle, or select D2:D101 and press Ctrl+D (Windows) / ⌘D (Mac).
  4. 4Spot-check a tricky row — Daniel O'Neil and Evelyn Smith-Jones must keep their punctuation exactly as entered.

Answer cells

Feedback

Type your formula in the grid, press Enter, then Check. We grade the value in each answer cell and the formula behind it.

Tasks

  1. Not checkedIn D2, join the first name (B2) and the last name (C2) with one space between them — CONCAT, CONCATENATE, TEXTJOIN or the & operator all count — then fill the formula down to D101.

Desktop recommended for spreadsheet tasks. The sheet scrolls inside this box.

StartInsertFormulasDataView
A1fxPreparing your workbook…
A
B
C
D
E
F
G
H
I
J
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Sheet1

Enter your formula in the sheet, then check.

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.

In these programs

  • Excel for Administrative AssistantsDay 6
  • Learn Excel From ScratchDay 4

Related exercises

  • Combine tags per product with TEXTJOINIntermediate, ~5 min
  • Clean padded, lower-case names with TRIM and PROPERIntermediate, ~6 min
  • Extract category, year and serial from SKUBeginner, ~6 min

Function reference

Official documentation

Next exercise

Extract category, year and serial from SKU