Find

Syntax

Find(Find_text, Within_text[, Start_num])

Parameters

Find_text. Substring you want to find in the source string.

Within_text. Source string, within which the text is searched.

Start_num. Optional parameter. Position of the source string element, from which the search is started. If it is not defined, a substring will be searched from the beginning of the source string.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

Description

It returns one text string within another and returns its position.

Comments

The search starts from the specified character of the source string, and it is case-sensitive. If the source string does not contain the searched string, the function returns #VAL. Element enumeration in the source string starts from 1.

Example

Formula	Result	Description
=Find("b", "BcBcab")	6	It returns the index of the first occurrence of the "b" string in the BcBcab source string starting from the first element in the source string.
=Find("b", "zzzzZ")	#VAL	The "b" substring has not been found in the "zzzzZ" source string.
=Find(B6, C6, E6)	5	It returns the index of the first occurrence of the string from the B6 cell in the C6 source string starting from the position specified by the number in the E6 cell. The B6 cell contains the A value while the C6 cell contains the AcbaA value, and the E6 cell contains the 2 value.