SEARCH/SEARCHB Function
The SEARCH/SEARCHB function is one of the text and data functions. Is used to return the location of the specified substring in a string. The SEARCH function is intended for languages that use the single-byte character set (SBCS), while SEARCHB - for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.
Syntax
SEARCH(find_text, within_text, start_num)
SEARCHB(find_text, within_text, start_num)
The SEARCH/SEARCHB function has the following arguments:
Argument |
Description |
find_text |
The substring to find. |
within_text |
The string to search within. |
start_num |
The position to start searching from. It is an optional argument. If it is omitted, the function will perform the search from the beginning of within_text. |
Notes
The SEARCH/SEARCHB function is NOT case-sensitive.
If the function does not find the matches, it will return a #VALUE! error.
How to apply the SEARCH/SEARCHB function.
Examples
The figure below displays the result returned by the SEARCH function.
![SEARCH Function](https://test-helpcenter.onlyoffice.com/OfficeWeb/apps/spreadsheeteditor/main/resources/help/en/images/search.png)
Return to previous page