Which of the following functions can you use to combine two or more strings into one text string? Select all the options that apply.
A) SUBSTITUTE
B) CONCAT
C) TOGETHER
D) TEXTJOIN

Question

Quizplus · Accepted Answer

CONCAT and TEXTJOIN are both functions that can be used to combine two or more strings into one text string. CONCAT is used to join two or more strings together in sequence, while TEXTJOIN allows you to specify a delimiter and ignore empty cells. SUBSTITUTE and TOGETHER are not functions that can be used for this purpose.

Which of the Following Functions Can You Use to Combine