Question

20) Which of the following functions would take the word "Joe" (found in column A) and "Smith" (found in column B), and display "Joe Smith" in column C?

A. COMBINETEXT


B. TEXTJOIN


C. JOINTEXT


D. JOIN

Answer 1

TextJoin

Step-by-step explanation:

Is the functions would take the word "Joe" (found in column A) and "Smith" (found in column B), and display "Joe Smith" in column C.

Answer 2

TEXTJOIN

Step-by-step explanation:

• TEXTJOIN is a common function of Ms Excel or Microsoft Excel

This function requires three arguments

1. delimiter
2. ignore_empty
3. text1.