Home »
MCQs »
Microsoft Excel MCQs
Which function is used to get the location of text in a string in MS Excel?
53. Which function is used to get the location of text in a string in MS Excel?
- FIND()
- INDEX()
- SEARCH()
- STRINGSEARCH()
Answer: C) SEARCH()
Explanation:
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