Text Functions
Beginner
Text Concatenation
Combine text from multiple cells using concatenation.
Task:
You have first names in column A and last names in column B. Combine them into full names in column C with a space between them.
Learning Objectives:
- Learn text concatenation with &
- Understand string joining
- Practice combining cell values
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | First Name | Last Name | Full Name |
| 2 | John | Smith | |
| 3 | Jane | Doe | |
| 4 | Mike | Johnson | |
| 5 | Sarah | Wilson |
What this exercise teaches (contains the answer)
Text concatenation combines multiple text strings into one. The ampersand (&) operator is the most common way to join text in Excel.