In Excel, the Find function returns the location of a substring in a string. The search is case-sensitive. Description of Find Formula in Excel FIND formula can locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string. IMPORTANT: FIND formula is intended for use with languages that use the single-byte character set (SBCS), whereas FINDB is intended for use with languages that use the double-byte character set (DBCS). The default language setting on your computer affects the return value in the following way: FIND formula always counts each character, whether single-byte or double-byte, as 1, no matter what the default language setting is.