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.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of CONCAT and &
0/4The same formula in the other shapes it takes at work.
- Text Concatenation
Combine text from multiple cells using concatenation.
CoreBeginner - Join text and numbers into a label
Build a readable line out of a name and a figure.
Beginner - TEXTJOIN: join a row and skip the gaps
One address line from several columns, with no doubled commas where a part is missing.
Intermediate - Initials from two names
Join the first letter of each part rather than the whole thing.
Intermediate
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 |
Functions used here
What this exercise teachesMay contain the answer
Text concatenation combines multiple text strings into one. The ampersand (&) operator is the most common way to join text in Excel.