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)
SORT
CONCAT
TEXTJOIN
MERGE

Answer 1

The command that best suits Cecilia's needs for combining first, last, and middle names into a single cell, especially when some cells may be missing data, is **TEXTJOIN**.

TEXTJOIN allows you to concatenate text from multiple cells and can also ignore any empty cells or missing data, making it ideal for this situation.