CONCATENATE and CONCAT in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the CONCATENATE function do in Excel?

It joins two or more text strings into one continuous text string.

intermediate

How is CONCAT different from CONCATENATE?

CONCAT is a newer function that can join ranges and individual strings, while CONCATENATE only joins individual strings.

beginner

Write a formula to join the text in cells A1 and B1 with a space between using CONCATENATE.

CONCATENATE(A1, " ", B1)

intermediate

Write a formula to join the text in cells A1 to A3 using CONCAT.

CONCAT(A1:A3)

intermediate

Why might you prefer CONCAT over CONCATENATE in modern Excel versions?

Because CONCAT can handle ranges directly and is more flexible, making formulas shorter and easier to write.

Which function can join a range of cells directly in Excel?

A CONCAT

B CONCATENATE

C SUM

D LEFT

CONCAT can join ranges of cells directly, unlike CONCATENATE which requires individual cell references.

What will the formula =CONCATENATE("Hello", " ", "World") output?

A Hello, World

B HelloWorld

C Hello World

D Error

The formula joins the words with a space in between, producing 'Hello World'.

If A1 contains 'Good' and B1 contains 'Morning', what does =CONCAT(A1, B1) return?

A GoodMorning

B Good Morning

C Good, Morning

D Error

CONCAT joins the two strings directly without spaces unless you add them explicitly.

Which function is recommended for joining text in Excel 365 and later?

A CONCATENATE

B LEFT

C TEXTJOIN

D CONCAT

CONCAT is the modern replacement for CONCATENATE and is recommended for newer Excel versions.

What happens if you use CONCATENATE with a range like A1:A3?

A It joins all cells in the range

B It returns an error

C It joins only the first cell

D It sums the values

CONCATENATE does not accept ranges and will return an error if you try.

Explain how to join text from multiple cells with spaces using CONCATENATE and CONCAT.

Think about how spaces are added between words.

Describe the advantages of using CONCAT over CONCATENATE in Excel.

Focus on flexibility and ease of use.