fx =TEXTJOIN(" ",TRUE,A1,B1,C1)ABCJohnSmithJohn SmithJaneDoeJane DoeAlexWongAlex Wong
📝 Text

CONCATENATE / TEXTJOIN Formula for Text Manipulation

Join text from multiple cells. Copy-paste ready for Excel, Google Sheets, and Airtable.

=TEXTJOIN(" ",TRUE,A1,B1,C1)
When you need this: When you need to create full names by combining first name (A1), middle initial (B1), and last name (C1).

How it works

  1. 1The TEXTJOIN function combines text from multiple cells.
  2. 2The delimiter (" ") is placed between each value.
  3. 3The TRUE flag means ignore empty cells.

Variations

Combine with custom separator
=TEXTJOIN(", ",TRUE,A1,B1,C1)
Join entire column with line breaks
=TEXTJOIN(CHAR(10),TRUE,A1:A100)

Related Formulas

LEFT / RIGHT / MID — Extract part of a text stringTextLEN — Count the number of characters in textTextTRIM — Remove extra spaces from textTextTEXT — Format a number as text with a specific formatText

Need a formula that's not here?

Generate custom formula →