Question

_____ function joins text strings.

• A. Join
• B. Concat
• C. Merge
• D. Combine

Hint:

Common Excel text functions:
• CONCAT $\rightarrow$ Joins text strings.
• TEXTJOIN $\rightarrow$ Joins text using a delimiter.
• LEFT/RIGHT/MID $\rightarrow$ Extract parts of text.
• LEN $\rightarrow$ Counts characters.

Answer 1

The Correct Option is B

Concept: The CONCAT function in Microsoft Excel is used to join (concatenate) two or more text strings into a single string. It replaces the older CONCATENATE() function in newer versions of Excel. Its syntax is: \[ \boxed{\texttt{=CONCAT(text1, text2, \ldots)}} \]

Step 1: Understand the CONCAT function.
The CONCAT function combines multiple text values into one. Example: If \[ A1=\text{"Hello"}, \qquad B1=\text{"World"} \] then \[ \boxed{\texttt{=CONCAT(A1," ",B1)}} \] returns \[ \boxed{\text{"Hello World"}} \]

Step 2: Know similar text functions.
Excel provides several text functions: {|l|l|} Function & Purpose
CONCAT & Joins text strings
TEXTJOIN & Joins text with a delimiter
LEFT & Extracts characters from the left
RIGHT & Extracts characters from the right
MID & Extracts characters from the middle
LEN & Counts the number of characters

Step 3: Analyse the options.

• Join -- Not an Excel function.
• Concat -- Correct; joins text strings.
• Merge -- Not an Excel text function.
• Combine -- Not an Excel function.

Step 4: Final conclusion.
Therefore, the function that joins text strings is: \[ \boxed{\text{CONCAT}} \]