FormulaCraft

CONCATENATE

CONCATENATE stitches multiple strings together in order. Modern Excel and Sheets also offer CONCAT and TEXTJOIN, but CONCATENATE remains widely used and universally supported.

Excel
=CONCATENATE(A2, " ", B2)
Google Sheets
=CONCATENATE(A2, " ", B2)
✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

FirstLast
JaneDoe

=CONCATENATE(A2, " ", B2)→Jane Doe

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

How it works

  1. 1A2 is the first piece of text.
  2. 2" " inserts a space between the parts.
  3. 3B2 is the second piece; "Jane" + " " + "Doe" = "Jane Doe".

Need a version for your data?

Try: “Join the first and last name with a space between them”

Related

TEXTJOINLEFT / RIGHT / MIDTRIM

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

Last reviewed: