Describe the benefits of using the TEXTJOIN function over the CONCAT function.

What will be an ideal response?


Although both functions combine text, TEXTJOIN can include a range of text cells without having to include separate arguments for a delimiter between each text string that is combined. TEXTJOIN has a delimiter argument automatically inserts the delimiter between the contents of each cell being combined. Another benefit is that the TEXTJOIN can ignore empty cells when combining text.

Computer Science & Information Technology

You might also like to view...

MC Items are______ on and______ off a stack.

a) pushed, topped. b) placed, knocked. c) pushed, popped. d) None of the above.

Computer Science & Information Technology

Playing an animation by manually dragging the playhead back and forth through the frames with your mouse is called previewing.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

With ________, tags are customized for use with content of a specific industry

Fill in the blank(s) with correct word

Computer Science & Information Technology

VMware's AirWatch and Cisco's Meraki Systems Manager are both examples of what type of software?

a. mobile device management software b. software defined network software c. virtual device management software d. cloud network management software

Computer Science & Information Technology