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

TEXTJOIN practice: one tag list per product from 5 columns

  • Intermediate
  • ~5 min
  • Text functions

The web-shop catalogue stores up to 5 tags per product in separate columns (C to G), and the 40 products use the slots unevenly: 31 rows have empty slots between tags, 6 use all five, 7 have a single tag. The storefront import wants one field per product with the tags separated by a comma and a space — for Standing desk that is "indoor, eco, fragile". Build that field in H2:H41 without producing stray separators for the empty slots.

What you need to do

  1. 1Click H2 and type =TEXTJOIN(", ",TRUE,C2:G2): the first argument is the delimiter, TRUE means "ignore empty cells", and C2:G2 is the range of tag slots.
  2. 2Press Enter — H2 shows indoor, eco, fragile. Compare with what =C2&", "&D2&", "&E2&", "&F2&", "&G2 would give: "indoor, , eco, , fragile", with separators for the empty slots.
  3. 3Fill H2 down to H41 (double-click the fill handle, or select H2:H41 and press Ctrl+D on Windows / ⌘D on Mac).
  4. 4Spot-check a product with a single tag — its cell must contain just the tag, no comma.

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 H2, use TEXTJOIN to combine the tags in C2:G2 with ", " as the delimiter and empty slots ignored, then fill down to H41.

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 40-row dataset on one sheet, one answer cell, about 5 minutes. Graded in your browser: the value and the formula behind it, with feedback that names the fix.

How to solve it

  • H2=TEXTJOIN(", ",TRUE,C2:G2)

TEXTJOIN takes a delimiter once, a flag that says whether empty cells are skipped, and then the cells to join — so one short formula replaces a chain of & operators with a separator between every pair. With ignore_empty set to TRUE the blank slots simply disappear: row 2 gives "indoor, eco, fragile" instead of "indoor, , eco, , fragile". The range C2:G2 is relative, so filling the formula down moves it to C3:G3, C4:G4 and so on.

Pitfall 1: TEXTJOIN(", ",FALSE,…) or CONCAT(C2,", ",D2,…) keep a separator for every slot and produce ", ," runs and trailing commas; cleaning those afterwards with SUBSTITUTE is fragile — use TRUE. Pitfall 2: a cell that looks empty but holds a formula returning "" counts as empty for TEXTJOIN (good), while a single space " " does not — TRIM the sources if the import pads blanks with spaces. Pitfall 3: TEXTJOIN returns #VALUE! once the result exceeds 32,767 characters — irrelevant for tags, relevant when joining whole columns of comments. Version note: TEXTJOIN and CONCAT arrived with Excel 2019 / 365; in Excel 2016 and earlier the only option is =C2&IF(D2<>"",", "&D2,"")&… or a helper column. The reverse operation is TEXTSPLIT(H2,", ") (Excel 365 only); for a conditional join — only tags of a given type — combine TEXTJOIN with FILTER: =TEXTJOIN(", ",TRUE,FILTER(C2:G2,C2:G2<>"eco")). Multiple delimiters are allowed: TEXTJOIN({", "," and "},TRUE,…) alternates them, handy for "a, b and c" sentences.

Other ways that work

  • =TEXTJOIN(", ",1,C2:G2) — 1 is accepted for TRUE
  • =TEXTJOIN(", ",TRUE,C2,D2,E2,F2,G2) — the slots listed individually
  • =TEXTJOIN(", ",TRUE,FILTER(C2:G2,C2:G2<>"")) — Excel 365; explicit filter instead of ignore_empty

Common mistakes

Setting ignore_empty to FALSE (or chaining the slots with &): the empty slots become extra separators and row 2 reads "indoor, , eco, , fragile" instead of "indoor, eco, fragile".

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.

Related exercises

  • Full name with CONCAT or &Beginner, ~4 min
  • Split email into user and domain (FIND/LEFT/RIGHT or TEXTBEFORE/TEXTAFTER)Intermediate, ~7 min
  • Clean padded, lower-case names with TRIM and PROPERIntermediate, ~6 min

Function reference

Official documentation

Next exercise

Days to deadline and tenure in years (TODAY, DATEDIF)