Searching for Strings (SEARCH – Case-Insensitive)
Syntax: SEARCH(Find_Text; Source_Text; Start_Number)
The SEARCH function finds the specified text string, find_text, within another text string, source_text, but unlike FIND, this function is not case-sensitive. For example:
=FIND("office"; "OpenOffice.org")
returns error #VALUE!, meaning the search term was not found, but
=SEARCH("office"; "OpenOffice.org")
returns 5, the starting position of the Office string within the OpenOffice.org string.
Figure 10-6. Sample result of the SEARCH function
The start_number argument enables you to change the position from which the search begins (default ...
Get Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
