Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to combine multiple columns into one in Excel and Google Sheets
Topic:Data cleaning & shapingHeads up: Excel and Google Sheets do this differently.
Excel
=A2&" "&B2&" "&C2Google Sheets
=TEXTJOIN(" ",TRUE,A2,B2,C2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| First | Middle | Last | Full Name |
| Alice | M | Smith | |
| Bob | Jones | ||
| Carol | A | Lee | |
| David | R | Kim | |
| Eve | Brown |
=A2&" "&B2&" "&C2→Alice M Smith
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Simple concatenation (both apps): In D2 type =A2&" "&B2&" "&C2 — replace " " with any delimiter like ", " or "-".
- 2In Google Sheets or Excel 2019+, use TEXTJOIN for cleaner syntax: =TEXTJOIN(" ",TRUE,A2:C2) — the TRUE argument skips empty cells.
- 3Copy the formula down all rows and the output updates as source data changes.
Tips
- TEXTJOIN is ideal when some cells may be blank — setting ignore_empty to TRUE means no double spaces or stray delimiters appear in the output.
Need it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
Frequently asked
What's the difference between CONCAT and CONCATENATE?
CONCAT accepts ranges; CONCATENATE only accepts individual cell references. Both join text without a delimiter. Use & or TEXTJOIN for delimiter control.
How do I combine an entire column into one cell?
Use TEXTJOIN with a range: =TEXTJOIN(", ",TRUE,A2:A100) — this joins all values in A2:A100 with a comma-space separator.
More on Data cleaning & shaping
See all →How-to
How to merge two columns
Combine two columns into one with the & operator — perfect for joining first and last names into a full name.
How-toHow to create a sequential invoice number
Automatically generate sequential invoice numbers with a prefix and zero-padded counter using TEXT and ROW in Excel and Google Sheets.
How-toHow to number rows within each group
Assign sequential row numbers that restart for each group using COUNTIF with a mixed reference in Excel and Google Sheets.
How-toHow to remove blank rows
Delete empty rows quickly by filtering for blanks and deleting visible rows, or use Go To Special in Excel for a one-click approach.
How-toHow to transpose rows to columns
Flip rows and columns using the TRANSPOSE function or Paste Special to convert horizontal data to vertical and vice versa.
How-toHow to fill blank cells with a value
Replace empty cells with a default value using IF+ISBLANK, Go To Special fill-down, or a Power Query step for bulk data.