Which of the following functions is not a text string manipulation tool?
A)CONCATENATE
B)MATCH
C)TRIM
D)LEFT

Name: Which of the following functions is not a text string manipulation tool? A)CONCATENATE B)MATCH C)TRIM D)LEFT
Brand: Quizplus
Rating: 4.9 (33 reviews)

Question

Quizplus · Accepted Answer

MATCH is not a text string manipulation tool. It is used to search for a specified item in a range of cells and returns the relative position of the item within that range. The other options (CONCATENATE, TRIM, LEFT) are all tools that manipulate text strings.

Which of the Following Functions Is Not a Text String