Combine Names using TEXTJOIN

Join text with a delimiter and skip empty cells automatically.

You will learn to

• Use a delimiter
• Ignore empty cells

How it works

TEXTJOIN(delimiter, ignore_empty, text1, …) joins text with a separator. =TEXTJOIN(" ",TRUE,A2:C2) joins first, middle and last names with spaces and skips empty middle names.

=TEXTJOIN(" ",TRUE,A2:C2)