Join text fields without extra spaces
Your goal: Build a readable name or label from three columns, even when the middle field is missing.
Full task requirements
Combine A, B and C into D2:D7 with one space between fields. Remove extra ordinary spaces.
Name badgesJoin the fields in row 2
Select the fields from one physical row. Quoted spaces remain visible.
| # | |||
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | |||
| 4 | |||
| 5 | |||
| 6 | |||
| 7 |
Step 1 of 6
Join the fields in row 2
Rules for this step
Choose all three fields from the same physical record. Join with one ordinary space, then collapse ordinary spaces. A numeric field becomes its text spelling.