If cell A2 contains the text string "red shorts",then =________(A2,3)will return the word "red".
A)LEFT
B)SEARCH
C)LEN
D)MID

Name: If cell A2 contains the text string "red shorts",then =________(A2,3)will return the word "red". A)LEFT B)SEARCH C)LEN D)MID
Brand: Quizplus
Rating: 4.7 (36 reviews)

Question

Quizplus · Accepted Answer

LEFT function is used to extract a given number of characters from the start of a string. In this case, using LEFT(A2,3) would return "red", the first three characters of the string "red shorts".

If Cell A2 Contains the Text String "Red Shorts",then =________(A2,3)will