Articles with the tag:
Articles with the tag:
Try in the cloud
Try in the cloud


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.


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.


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.


The figure below displays the result returned by the SEARCH function.

SEARCH Function

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action