FormulaCraft

TEXTJOIN

TEXTJOIN combines values with a delimiter and can ignore empty cells — cleaner than chaining & or CONCATENATE.

Excel
=TEXTJOIN(" ", TRUE, A2, B2)
Google Sheets
=TEXTJOIN(" ", TRUE, 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

Runs server-side · free · no signup

How it works

  1. 1" " is the separator between values.
  2. 2TRUE skips empty cells.
  3. 3A2, B2 are the values to join.

Need a version for your data?

Try: “Join first name in A2 and last name in B2 with a space”

Related

LEFT / RIGHT / MIDTRIMSUBSTITUTE

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

Last reviewed: