Skip to content

Combine text from several cells

Join first and last names, or any columns, with a separator and no stray spaces.

The formula

Argument separator
Excel and Google Sheets · Excel 2019 and newer
=TEXTJOIN(" ", TRUE, A2, B2, C2)
Works in every version
=TRIM(A2&" "&B2&" "&C2)

How it works

  1. " "

    The separator placed between the values. Use ", " for a comma list.

  2. TRUE

    Skip empty cells, so you never get double spaces.

  3. A2, B2, C2

    The cells or ranges to join.

Example

A: FirstB: MiddleC: LastD: Result
AnaMaríaRuizAna María Ruiz
TomLeeTom Lee

Tips

  • TEXTJOIN also accepts whole ranges: =TEXTJOIN(", ", TRUE, A2:A20).