CONCATENATE and CONCAT in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

What is the output of this CONCATENATE formula?

Given the cells:

A1 contains "Good"
B1 contains "Morning"

What is the result of the formula =CONCATENATE(A1, " ", B1)?

Excel

=CONCATENATE(A1, " ", B1)

A "Good, Morning"

B "GoodMorning"

C "Good Morning"

D "Good-Morning"

💡 Hint

Think about what the space " " inside the formula does.

The CONCATENATE function joins text strings exactly as given. The space " " adds a space between the words.

📊 Formula Result

intermediate

What does this CONCAT formula return?

If cell A2 contains "2024" and B2 contains "June", what is the output of =CONCAT(A2, "-", B2)?

Excel

=CONCAT(A2, "-", B2)

A "2024-June"

B "2024June"

C "2024 - June"

D "2024, June"

💡 Hint

Look at the character between the two cell references.

CONCAT joins the values with the exact characters you specify. The dash "-" is included as is.

❓ Function Choice

advanced

Which formula correctly joins cells A3, B3, and C3 with commas and spaces?

Cells contain:
A3: "Apple"
B3: "Banana"
C3: "Cherry"

Choose the formula that outputs: Apple, Banana, Cherry

A =CONCATENATE(A3, ", ", B3, ", ", C3)

B =CONCAT(A3 & ", " & B3 & ", " & C3)

C =CONCATENATE(A3 & ", " & B3 & ", " & C3)

D =CONCAT(A3, ", ", B3, ", ", C3)

💡 Hint

CONCAT can take multiple arguments separated by commas.

CONCAT accepts multiple arguments separated by commas and joins them. CONCATENATE requires each argument separately. Options B and C use & inside CONCATENATE or CONCAT which is invalid syntax.

📊 Formula Result

advanced

What is the output of this formula with empty cells?

If A4 is empty, B4 contains "Hello", and C4 contains "World", what does =CONCATENATE(A4, "-", B4, "-", C4) return?

Excel

=CONCATENATE(A4, "-", B4, "-", C4)

A "-Hello-World"

B "Hello-World"

C "--HelloWorld"

D "HelloWorld"

💡 Hint

Empty cells are treated as empty strings.

CONCATENATE treats empty cells as empty text, so the dashes remain in the output.

🎯 Scenario

expert

You want to join a range of cells A5:A7 with spaces between words. Which formula produces the correct result?

Cells contain:
A5: "I"
A6: "love"
A7: "Excel"

Which formula outputs: I love Excel?

A =CONCATENATE(A5, " ", A6, " ", A7)

B =CONCAT(A5:A7)

C =CONCAT(A5 & " " & A6 & " " & A7)

D =TEXTJOIN(" ", TRUE, A5:A7)

💡 Hint

CONCAT and CONCATENATE do not add separators automatically for ranges.

TEXTJOIN allows joining a range with a delimiter and can ignore empty cells. CONCAT and CONCATENATE do not accept ranges with delimiters.