CONCATENATE and JOIN in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to join the text in cells A1 and B1 without any space.

Google Sheets

=CONCATENATE(A1, [1])

Drag options to blanks, or click blank then click option'

A" "

BC1

CA2

DB1

Attempts:

3 left

💡 Hint

Common Mistakes

Using a space " " instead of the cell reference B1.

Using the wrong cell like A2 or C1.

The CONCATENATE function joins text strings. To join A1 and B1, you must include B1 as the second argument.

2fill in blank

medium

Complete the formula to join the text in cells A1, B1, and C1 with a comma and space between each.

Google Sheets

=JOIN([1], A1:C1)

Drag options to blanks, or click blank then click option'

A" "

B", "

C"; "

D","

Attempts:

3 left

💡 Hint

Common Mistakes

Using a semicolon "; " instead of a comma.

Forgetting the space after the comma.

The JOIN function combines text with a delimiter. To separate with a comma and space, use ", ".

3fill in blank

hard

Fix the error in the formula to join cells A1 and B1 with a dash between them.

Google Sheets

=CONCATENATE(A1, [1], B1)

Drag options to blanks, or click blank then click option'

A" "

B-

C"-"

D,

Attempts:

3 left

💡 Hint

Common Mistakes

Using - without quotes causes an error.

Using a comma instead of a dash.

The dash must be a text string inside quotes "-" to be joined properly.

4fill in blank

hard

Fill both blanks to create a formula that joins cells A1 to A3 with a semicolon and space between each.

Google Sheets

=JOIN([1], [2])

Drag options to blanks, or click blank then click option'

A"; "

BA1:A3

CA1:C1

D" "

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong range like A1:C1.

Using a space " " instead of "; ".

JOIN needs the delimiter first, here "; ", then the range A1:A3 to join those cells.

5fill in blank

hard

Fill all three blanks to create a formula that concatenates the uppercase of cell A1, a space, and the lowercase of cell B1.

Google Sheets

=CONCATENATE([1](A1), [2], [3](B1))

Drag options to blanks, or click blank then click option'

AUPPER

B" "

CLOWER

DPROPER

Attempts:

3 left

💡 Hint

Common Mistakes

Using PROPER instead of LOWER for the last function.

Forgetting quotes around the space.

Using LOWER for the first blank instead of UPPER.

Use UPPER(A1) to make uppercase, then a space " ", then LOWER(B1) for lowercase.