← Back to level 1
Level 1Level 1
CONCAT
Joins text together from multiple cells or values.
Syntax
=CONCAT(text1, [text2], ...)Step-by-step explanation
- 1Select all the text pieces you want to combine.
- 2Add spaces or separators manually when needed.
- 3Useful for building labels and readable outputs.
Common mistakes
Forgetting separators
Using numbers without formatting them first
Choosing CONCATENATE in older templates unnecessarily
Example table
A quick scenario to connect the syntax to the result.
| Excel | Hub |
Formula
=CONCAT(A1," ",B1)
Result
Excel Hub
Practice area
Join first and last names into one string.
Match against the syntax block above.