FIND/FINDB Function

The FIND/FINDB function is one of the text and data functions. Is used to find the specified substring (find_text) within a string (within_text). The FIND function is intended for languages that use the single-byte character set (SBCS), while FINDB - for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.

Syntax

FIND(find_text, within_text, [start_num])

FINDB(find_text, within_text, [start_num])

The FIND/FINDB function has the following arguments:

Argument	Description
find_text	A string you are looking for.
within_text	A string you are searching within.
start_num	A position in a string where the search will start. It is an optional argument. If it is omitted, the funcion will start search from the beginning of the string.

Notes

The FIND/FINDB function is case-sensitive.

If there are no matches, the function will return the #VALUE! error.

How to apply the FIND/FINDB function.

Examples

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

Return to previous page