Names run together
A separator must be entered as text, for example " ". A space outside quotation marks is not part of the result.
Join text fields without extra spaces
Read-only
Step-by-step guide · read-only ·
Loading your interactive spreadsheet…
Preparing the worksheet and formulas…
Data & tools
Task requirements
Combine A, B and C into D2:D7 with one space between fields. Remove extra ordinary spaces.
Follow the highlighted cells. Switch to Your turn to edit. Answer cells: D2, D3, D4, D5, D6, D7. Browser calculations may differ from your Excel version.
Selection & formula search
Practice stays on this device. No worksheet data is uploaded.
Notes & examples
About this lesson
Build a readable name or label from three columns, even when the middle field is missing.
Choose the result you need
Join A, B and C with quoted spaces, then apply TRIM to remove excess ordinary spaces. An empty middle field leaves no double gap. Fill D2:D7.
=TRIM(A2&" "&B2&" "&C2)TRIM also collapses repeated ordinary spaces within fields. Use it when that cleanup is intended. It does not remove every Unicode space or preserve all numeric display formats.
All result formulas
- D2
=TRIM(A2&" "&B2&" "&C2)- D3
=TRIM(A3&" "&B3&" "&C3)- D4
=TRIM(A4&" "&B4&" "&C4)- D5
=TRIM(A5&" "&B5&" "&C5)- D6
=TRIM(A6&" "&B6&" "&C6)- D7
=TRIM(A7&" "&B7&" "&C7)
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | "First field" | "Optional field" | "Last field" | "Joined label" |
| 2 | "Ava" | — | "Reed" | "Ava Reed" |
| 3 | "Leo" | "M." | "Chen" | "Leo M. Chen" |
| 4 | " Noor " | — | "Patel" | "Noor Patel" |
| 5 | "Sam" | " Lee " | "Rivera" | "Sam Lee Rivera" |
| 6 | — | — | "Support" | "Support" |
| 7 | "Team" | 7 | "West" | "Team 7 West" |
These are reference examples with matching downloads. The primary worksheet below has its own stated task and checks; choosing an example here leaves that worksheet and your progress unchanged.
Open the primary practice ↓Microsoft function reference ↗ · Browser calculations checked. Native Excel and Google Sheets recalculation of these reference files has not been verified.
How it works
Pick a separator deliberately
This task builds human-readable labels with spaces. A comma, hyphen or other separator is a separate formatting choice. TRIM is useful here because extra ordinary spaces are unwanted; do not use it when repeated spaces carry meaning.
Text and number appearance
Joining a numeric value uses its underlying value, not every visual number format. A numeric 7 will not turn into 007 by itself. Store an ID as text when its leading zeros must survive, or use an explicit TEXT format in your own workbook.
Other ways to combine text
CONCAT and TEXTJOIN can also combine values. They solve the same joining task, so you do not need to learn them before trying this example. The ampersand version makes the separator and field order visible.
Read the full step-by-step walkthrough
- Read the parts in order
The label should use the first field, optional middle field and final field, in that order.
- Connect two cells
An ampersand joins text. Without a separator, the words run together.
A2&B2 - Insert a space
Put a space inside quotation marks between the cell references. Repeat for the third field.
A2&" "&B2&" "&C2 - Handle an empty middle field
An empty field leaves two adjacent spaces. TRIM reduces them to one and removes spaces at either end.
TRIM(…) - Fill down and test a missing field
Fill D2:D7. Try removing the optional field, then adding it back; the formula should keep the label readable.
Things to watch
Missing fields create double spaces
TRIM cleans ordinary repeated spaces after the fields are joined.
Leading zeros disappear
A number and a text ID are different data. Preserve the ID as text if its zeros matter.
About this example
Published examples, formula filling and practice checks were tested in Chrome on October 13, 2026. Tests cover the supplied datasets and stated input rules, not every possible formula. These workbooks have not yet been independently recalculated in Microsoft Excel or Google Sheets.
Content version 2. Practice checks compare calculated results across different datasets; they do not certify every possible formula.