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?

1. FIND()
2. INDEX()
3. SEARCH()
4. 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