CONCATENATE and CONCAT in Excel - Cell-by-Cell Formula Trace

Sample Data

This data contains words in two columns A and B that we will join together using CONCATENATE and CONCAT formulas.

Cell	Value
A1	Hello
A2	World
A3	!
B1	Good
B2	Morning
B3	Everyone

Formula Trace

=CONCATENATE(A1, " ", A2, A3)

Step 1: CONCATENATE("Hello", " ", "World", "!")

Cell Reference Map

Hello

↓

World

↓

!

The formula uses cells A1, A2, and A3 from column A to join their text values.

Result

    A       B       C
1 Hello   Good   Hello World!
2 World  Morning
3 !      Everyone

Cell C1 shows the result of CONCATENATE formula.

The result "Hello World!" appears in cell C1 after joining A1, a space, A2, and A3.

Sheet Trace Quiz - 3 Questions

What does the formula =CONCATENATE(A1, " ", A2, A3) produce?

A HelloWorld!

B Hello World!

C Hello World !

D Hello World

Key Result

CONCATENATE and CONCAT join multiple text values or cell contents into one continuous text string.