After truncation, if Position is greater than the length of the string to be searched, then SEARCH reports a #VALUE! error.If Position is less than 1, then SEARCH reports an invalid argument error (Err:502).If Position is a non-integer value, then SEARCH truncates it to an integer value.If Position is omitted, SEARCH uses the value 1. Position is a positive integer, or a reference to a cell containing a positive integer, that is the character position from which the search starts. Text is a text string (in quotation marks), a number, or a reference to a cell containing one of those types, that is the string to be searched. The value returned cannot be greater than the length of the string to be searched.įindText is a text string (in quotation marks), a number, or a reference to a cell containing one of those types, that is the string to be found. Returns a positive integer which is the position of the first character of the first occurrence of the string to be found, within the string to be searched.

By default, the search is not case-sensitive, but a case-sensitive match can be carried out when using a regular expression. SEARCH can be used with either wildcards or regular expressions.

Locates the character position of the first occurrence of one text string within another.

Libre calc