Returns the number of a character or string that begins the string found within another string
Function structure:
= search.text ('what are we looking for'; 'where we are looking'; [optional - from which place we are looking]
An example of using the formula in practice:
A1 - value = FV / 2013/11/08 / USEx / P
In such a record, let's assume that we are looking for the USEx mark - which means that the invoice concerns a training service in the field of Ms Excel. The form of the formula will be as follows:
= search.text ("USEx"; a1)
the result is 15, which is the starting position for the string we are looking for.
ATTENTION
If the searched value does not exist in the searched cell, the function returns an error. Naturally, this can be remedied by using the additional "do.error" function.