How to combine two columns in Excel and Google Sheets

Excel & Google Sheets

=A2&" "&B2

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

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

Step by step

1In a new column, type =A2&" "&B2 to join with a space between.
2Change " " to any separator — ", " for a comma, "" for none.
3Copy the formula down the column.

Tips

TEXTJOIN(" ", TRUE, A2, B2) joins many cells and skips empty ones.
Wrap a name in PROPER() to fix inconsistent capitalisation while you combine.

Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.

Frequently asked

What is the difference between & and CONCATENATE?

They do the same thing. The & operator is shorter; TEXTJOIN is better when you need a delimiter and want to ignore blank cells.

Formulas used

TEXTJOIN TRIM

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026