CONCATENATE and CONCAT in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to join the text in cells A1 and B1 using CONCATENATE.

Excel

=CONCATENATE(A1, [1])

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

AA2

BSUM(B1)

CB1

D"B1"

Attempts:

3 left

💡 Hint

Common Mistakes

Using quotes around B1 like "B1" which treats it as text, not a cell reference.

Using a function like SUM instead of a cell reference.

The CONCATENATE function joins text from multiple cells. To join A1 and B1, you use B1 as the second argument.

2fill in blank

medium

Complete the formula to join text in A1 and B1 with a space between using CONCAT.

Excel

=CONCAT(A1, [1], B1)

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

A"-"

BCHAR(10)

CSPACE()

D" "

Attempts:

3 left

💡 Hint

Common Mistakes

Using CHAR(10) which adds a line break instead of a space.

Using SPACE() which is not a valid Excel function.

To add a space between joined texts, use " " (a space inside quotes) as the separator.

3fill in blank

hard

Fix the error in the formula to join A1 and B1 with a comma and space using CONCATENATE.

Excel

=CONCATENATE(A1, [1], B1)

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

A", "

B","

C", ""

D", """

Attempts:

3 left

💡 Hint

Common Mistakes

Leaving out the space after the comma.

Adding extra quotes causing syntax errors.

The separator should be a comma and space inside quotes: ", " to join text properly.

4fill in blank

hard

Fill both blanks to create a formula that joins A1, a dash, and B1 using CONCAT.

Excel

=CONCAT(A1, [1], [2])

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

A"-"

BB1

CA1

D" "

Attempts:

3 left

💡 Hint

Common Mistakes

Using A1 again instead of B1 for the last text.

Using a space instead of a dash as separator.

The dash "-" is the separator, and B1 is the last text to join.

5fill in blank

hard

Fill all three blanks to create a formula that joins uppercase A1, a comma and space, and lowercase B1 using CONCATENATE.

Excel

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

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

AUPPER(A1)

B", "

CLOWER(B1)

DPROPER(A1)

Attempts:

3 left

💡 Hint

Common Mistakes

Using PROPER instead of UPPER or LOWER for case conversion.

Forgetting quotes around the separator.

Mixing up the order of arguments.

Use UPPER(A1) to convert A1 to uppercase, ", " as separator, and LOWER(B1) to convert B1 to lowercase before joining.