CONCAT
Joins pieces of text together.
How it’s written
CONCAT(text1, text2)Example
| A | B | |
|---|---|---|
| 1 | First | Last |
| 2 | Amara | Osei |
=CONCAT(A2," ",B2)Result: Amara Osei
Joins the names with a space between them.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
The & sign does the same job, and is often quicker to type.
Practice it properly
Joining text together gives you real tasks, with your formulas tested on data you haven’t seen.