← Back to level 1
Level 1Next
CONCATENATE
An older easy text formula for joining multiple pieces of text into one result.
Syntax
=CONCATENATE(...)Step-by-step explanation
- 1Pick the text cells or values that need to be combined or reformatted.
- 2Use the formula to extract, join, or format the text in the way you need.
- 3Press Enter and read the output as a cleaned-up label or string.
Common mistakes
Using it when CONCAT or TEXTJOIN would be simpler
Forgetting separators
Combining numbers before formatting them
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 42 |
Formula
=CONCATENATE(A1:B2)
Result
42
Worked example
- 1Inspect the source text in the sample table and decide what should change.
- 2Enter =CONCATENATE(A1:B2) to format, join, or extract the text.
- 3The final text result should read 42.
Practice area
Use CONCATENATE when you are working in a legacy workbook that still depends on older text formulas.
Match against the syntax block above.