Which function is used to get the location of text in a string in MS Excel?
FIND()
INDEX()
SEARCH()
STRINGSEARCH()
Correct answer is C
The SEARCH() function is used to get the location of text in a string.
Syntax:
=SEARCH (find_text, within_text, [start_num])
Example:
=SEARCH("How","Hello, world! How are you?") // Returns 15