Excel + Google Sheets · &

Join cells with one symbol

The & symbol glues texts together. Add " " for a space.

The formula

=A2 & " " & B2

What each part means

A2First piece
" "A space
B2Second piece

Example

Before

	A	B	C
1	First	Last	Full name
2	Laura	Gómez
3	João	Silva
4	Priya	Shah

After

	A	B	C
1	First	Last	Full name
2	Laura	Gómez	Laura Gómez
3	João	Silva	João Silva
4	Priya	Shah	Priya Shah

Step by step

Click cell C2.
Type the formula: =A2 & " " & B2
Press Enter.
Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.

Where it works

Every version of Excel
Google Sheets
Excel for the web (free)

The same formula in other languages

English &
Español &
Português &

Get 1 formula a day, free

Plus a free weekly planner template for Excel and Google Sheets. Unsubscribe in 1 click.

✓ Done! Check your inbox to confirm.

Want ready-made templates? See the Formulyo pack →

Keep learning

Running totalRunning totals with one $Progress %Project progress in one cell IFERRORHide every #DIV/0!ROUNDRound any number the right way COUNTA + UNIQUECount unique values TEXTAFTERCut any text after a character