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.

Practice

1. What does the CONCATENATE function do in Excel?

easy

A. Calculates the sum of numbers in cells

B. Joins text from multiple cells into one text string

C. Finds the average of numbers in cells

D. Sorts data alphabetically

Solution

1. Step 1: Understand CONCATENATE function purpose

   The CONCATENATE function joins text from different cells into one continuous text string.

2. Step 2: Compare with other options

   Options A, C, and D describe different functions unrelated to joining text.

3. Final Answer:

   Joins text from multiple cells into one text string -> Option B

4. Quick Check:

   CONCATENATE joins text = Joins text from multiple cells into one text string [OK]

Hint: CONCATENATE joins text pieces into one string [OK]

Common Mistakes:

• Thinking CONCATENATE sums numbers
• Confusing CONCATENATE with sorting functions
• Assuming CONCATENATE finds averages

2. Which of the following is the correct syntax to join cells A1 and B1 with a space using CONCAT?

easy

A. =CONCAT(A1, " ", B1)

B. =CONCAT(A1 + " " + B1)

C. =CONCATENATE(A1 B1)

D. =CONCAT(A1 & B1)

Solution

1. Step 1: Review CONCAT syntax

   CONCAT joins text items separated by commas; to add space, include " " as an argument.

2. Step 2: Check each option

   =CONCAT(A1, " ", B1) correctly uses commas and includes space as " ". Others use incorrect operators or missing commas.

3. Final Answer:

   =CONCAT(A1, " ", B1) -> Option A

4. Quick Check:

   CONCAT uses commas and quotes for spaces = =CONCAT(A1, " ", B1) [OK]

Hint: Use commas and " " for spaces inside CONCAT [OK]

Common Mistakes:

• Using plus (+) instead of commas in CONCAT
• Missing commas between arguments
• Using CONCATENATE syntax with CONCAT incorrectly

3. Given cells: A1 = "Good", B1 = "Morning", what is the result of =CONCATENATE(A1, " ", B1)?

medium

A. Good Morning

B. Good+Morning

C. Good, Morning

D. GoodMorning

Solution

1. Step 1: Understand CONCATENATE with spaces

   The formula joins A1 and B1 with a space " " between them.

2. Step 2: Combine the texts

   "Good" + " " + "Morning" results in "Good Morning" with a space.

3. Final Answer:

   Good Morning -> Option A

4. Quick Check:

   CONCATENATE adds space = "Good Morning" [OK]

Hint: Add " " inside CONCATENATE for spaces [OK]

Common Mistakes:

• Forgetting to add space argument
• Expecting comma or plus signs in output
• Confusing CONCATENATE with automatic spacing

4. Identify the error in this formula: =CONCATENATE(A1 B1) to join cells A1 and B1.

medium

A. Extra parentheses used

B. CONCATENATE cannot join cells

C. Missing comma between A1 and B1

D. Spaces are not allowed in CONCATENATE

Solution

1. Step 1: Check CONCATENATE argument syntax

   Arguments must be separated by commas; here A1 and B1 are missing a comma.

2. Step 2: Confirm other options

   CONCATENATE can join cells, parentheses are correct, spaces are allowed inside strings.

3. Final Answer:

   Missing comma between A1 and B1 -> Option C

4. Quick Check:

   Arguments need commas = Missing comma between A1 and B1 [OK]

Hint: Separate CONCATENATE arguments with commas [OK]

Common Mistakes:

• Omitting commas between arguments
• Thinking CONCATENATE can't join cells
• Misplacing parentheses

5. You have cells A1:A3 with values "Red", "Green", "Blue". Which formula using CONCAT correctly joins them with commas and spaces to get "Red, Green, Blue"?

hard

A. =CONCAT(A1:A3)

B. =CONCATENATE(A1 & ", " & A2 & ", " & A3)

C. =CONCAT(A1:A3, ", ")

D. =CONCAT(A1, ", ", A2, ", ", A3)

Solution

1. Step 1: Understand CONCAT with multiple arguments

   CONCAT joins each argument in order; to add commas and spaces, include them as separate text arguments.

2. Step 2: Evaluate each option

   =CONCAT(A1, ", ", A2, ", ", A3) correctly joins A1, ", ", A2, ", ", A3 producing "Red, Green, Blue". =CONCATENATE(A1 & ", " & A2 & ", " & A3) uses CONCATENATE with & which works but is not CONCAT. =CONCAT(A1:A3, ", ") incorrectly tries to add separator to a range. =CONCAT(A1:A3) joins without commas.

3. Final Answer:

   =CONCAT(A1, ", ", A2, ", ", A3) -> Option D

4. Quick Check:

   CONCAT with commas as text = =CONCAT(A1, ", ", A2, ", ", A3) [OK]

Hint: Add commas as separate text arguments in CONCAT [OK]

Common Mistakes:

• Using range with CONCAT expecting separators
• Confusing CONCAT with CONCATENATE syntax
• Forgetting to add commas and spaces manually