Text tool basics in Figma - Cell-by-Cell Formula Trace

Sample Data

This data represents simple text strings in column A and spaces in column B, used to demonstrate text concatenation with the Text tool basics.

Cell	Value
A1	Hello
A2	World
A3	123
B1
B2
B3
C1	Hello World
C2	World 123
C3	123 123

Formula Trace

=A1 & B1 & A2

Step 1: A1

Step 2: B1

Step 3: A2

Step 4: A1 & B1

Step 5: A1 & B1 & A2

Cell Reference Map

Hello

↓

World

↓

123

Cells A1, B1, and A2 are referenced in the formula to concatenate text with spaces.

Result

Hello

↓

World

↓

123

The final result in cell C1 is the combined text string "Hello World" created by joining the text in A1, a space in B1, and the text in A2.

Sheet Trace Quiz - 3 Questions

What does the formula =A1 & B1 & A2 produce?

A "HelloWorld"

B "World Hello"

C "Hello World"

D "Hello World"

Key Result

Concatenate text strings using & operator to join cells with optional spaces.