Comma separator
=TEXTJOIN(", ",TRUE,A2:C2)Joins address or category parts with commas.
PASTE-READY RECIPE
Combine Multiple Columns in Google Sheets
Join names, labels or address parts while skipping empty cells.
QUICK ANSWER
The formula and where it fits.
Join names, labels or address parts while skipping empty cells. Use =TEXTJOIN(" ",TRUE,A2:C2), then replace the sample ranges with the columns in your sheet.
TEXTJOIN inserts a separator and ignores blank cells when the second argument is TRUE.
- Put the source data under one header row.
- Paste the formula into an empty result cell.
- Change the ranges and criteria to match your sheet.
- Check the result against one row you can verify manually.
TRY ITEdit the table.
Edit the table.
Watch the result change.
| A | B | C | |
|---|---|---|---|
| 1 | First | Middle | Last |
| 2 | |||
| 3 | |||
| 4 |
FORMULA OUTPUTMaya Chen · Leo J Martin · Nia PatelRecalculates from the input cells above
VARIATIONS
Use the version that fits your sheet.
Ampersand
=A2&" "&B2Best for two required cells.
Whole columns
=ARRAYFORMULA(IF(A2:A="","",A2:A&" "&C2:C))Fills the result column automatically.
COMMON ERRORS
When the result looks wrong.
Extra spaces appear
Use TEXTJOIN with ignore_empty set to TRUE.
Numbers lose formatting
Wrap numeric pieces in TEXT with the desired format.
QUESTIONS
Answers before you paste.
Extra spaces appear
Use TEXTJOIN with ignore_empty set to TRUE.
Numbers lose formatting
Wrap numeric pieces in TEXT with the desired format.
MAKE IT YOURS
Adjust this formula →Change the ranges, labels or criteria.
Send this recipe to the SheetSteps assistant and describe how your columns are arranged.