Which function is used to get the location of text in a s...
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
A ________ is a collection of predefined design elements and color schemes. ...
Which of the following Charts can be created in Excel? ...
Which of the cell pointer indicates that you can fill series? ...
What is the full form of OLE in MS Access ? ...
In PowerPoint, a new presentation can be created from ...
If I create 'Student' field in 'Fees' table to store 'student_id' of 'St...
In MS Excel, the currently selected cell address is displayed in ____ ...