(such as, turn the three cells “Mr.”, “Juan”, and “Ruiz” into one cell saying “Mr. Juan Ruiz”).
Why is CONCAT preferable over Merge?
(1 point)
Merge only works on empty cells; CONCAT works on any cell.
Merge is for styling cells; CONCAT is for combining text.
Merge only works on numbers; CONCAT works on anything.
Merge adds a space between each string; CONCAT doesn’t.
1 answer
The correct answer is: Merge is for styling cells; CONCAT is for combining text.
This reflects the fact that the CONCAT function is used to combine text strings from multiple cells, while merging cells is more about formatting and does not necessarily combine the contents of those cells into a single text string.
