Which function joins two or more text strings into one text string?

CONCATENATE

The correct answer is option 2- CONCATENATE.

CONCATENATE This function joins two or more text strings into one text string and its syntax is CONCATENATE (text1, text2,...) where text1, text2, …. are 2 to 255 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references. Example combining First Name,  Middle Name and Surname of the employees into Full Name using CONCATENATE Function.

OTHER OPTIONS

• SUMIF is the function which adds the cells as per given specified criteria.
• COUNTIF- This function counts the number of cells within a range that meet the given criteria; in this function the Range is one or more cells to count, including numbers or names, arrays, or references that contain numbers. The blank cells and text values are ignored.
• TEXT- This function converts a numeric value to text in a specific number format.