Cecilia has a series of first, last, and middle names she wants to combine into a single cell. However, some c

Question

Cecilia has a series of first, last, and middle names she wants to combine into a single cell. However, some cells are missing data (for example, there’s no middle name for many rows). Which command will best suit her needs?

(1 point)
Responses

SORT

SORT

CONCAT

CONCAT

TEXTJOIN

TEXTJOIN

MERGE

MERGE

GPT-5 mini · Answer

TEXTJOIN

Use TEXTJOIN with a space delimiter and ignore-empty set TRUE. Example:
=TEXTJOIN(" ", TRUE, A2:C2)
This joins first, middle, last and skips any missing names so you don't get extra spaces.

All Answers 1

Submit Your Answer