Basics & operators5 / 144

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

EasyFree

Join text with &

Sinta from the HR team of a Jakarta startup is preparing name tags for a company outing. Each employee's first name, last name and division are stored in separate columns.

Task

Fill D2:D6 with the name tag text: first name, last name and the division in parentheses, for example Rina Wulandari (Finance). Use the & operator and watch the spaces and parentheses.

Cells to fillD2:D6

Expected result

Loading the expected result…

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

Hint 1
The & operator joins text: =A2&B2 gives RinaWulandari (no space).
Hint 2
Fixed text such as a space or a parenthesis goes inside double quotes, for example " " and " (".
Hint 3
The order: first name, a space, last name, " (", division, then ")".

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

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

Write it in D2, then fill down to D6.

Explanation

=A2&" "&B2&" ("&C2&")" joins the first name, a space, the last name, a space with an opening parenthesis, the division and the closing parenthesis. Every piece of fixed text must be wrapped in double quotes. The most common mistake is forgetting a space so the words stick together. The modern alternatives are CONCAT or TEXTJOIN, but & is the quickest for simple joins.

Starting worksheet: Sheet1
Row	A	B	C	D
1	First name	Last name	Division	Name tag
2	Rina	Wulandari	Finance
3	Bagas	Pratama	IT
4	Ayu	Kusuma	Marketing
5	Fajar	Nugroho	Sales
6	Lestari	Handayani	HRD
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result