Text & REGEX › CONCATENATE18 / 67

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFreeCONCATENATE

CONCATENATE: name tag text

The HR team of an office in Balikpapan is preparing name tags for a company gathering. The employee data keeps first name, last name, and division apart, but on the name tag all three appear on one line.

Task

In D2:D6, build the name tag text in the format First Last - Division (example: Fajar Nugroho - Finance) using CONCATENATE, written in D2 and copied down to D6. Mind the spaces and the hyphen.

Cells to fillD2:D6

Required functionsCONCATENATE

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
CONCATENATE joins all its arguments from left to right without adding any separator.
Hint 2
You have to add the space and the hyphen yourself as text: " " and " - ".
Hint 3
Pattern: =CONCATENATE(A2, " ", …, " - ", …).

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

D2:D6

=CONCATENATE(A2," ",B2," - ",C2)

Write it in D2, then fill down to D6.

Explanation

=CONCATENATE(A2," ",B2," - ",C2) joins five pieces into "Fajar Nugroho - Finance". The most common mistake is forgetting the spaces, which gives "FajarNugroho-Finance". In Google Sheets, CONCAT only accepts two values, so for more pieces use CONCATENATE or the & operator (=A2&" "&B2&" - "&C2). If the separator is always the same, JOIN and TEXTJOIN are shorter.

Starting worksheet: Sheet1
Row	A	B	C	D
1	First name	Last name	Division	Name tag
2	Fajar	Nugroho	Finance
3	Lestiani	Purba	Marketing
4	Made	Wirawan	Warehouse
5	Theresia	Manurung	IT
6	Rizal	Ramadhan	HR
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result