Asked by Madeline Lombardo on May 21, 2024
Verified
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
CONCAT
CONCAT is a function in many programming and query languages that combines two or more strings (text values) into one continuous string.
SUBSTITUTE
A function in various programming and scripting languages that replaces occurrences of a specified substring within a string with another substring.
TEXTJOIN
A function in some spreadsheet programs that combines the text from multiple ranges or strings, and optionally places a delimiter between elements.
- Comprehend the application of Excel functions for capitalizing letters, merging strings, and joining text.
Verified Answer
AL
Aashrith LopellyMay 24, 2024
Final Answer :
B, D
Explanation :
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.
Learning Objectives
- Comprehend the application of Excel functions for capitalizing letters, merging strings, and joining text.