FINDB
Formula Explanation
Used to locate the position of the first text string within the second text string and returns the value of the starting position of the first text string. This value is counted from the first character of the second text string.
Formula Syntax
Enter in the result column: FINDB(text to find / column number, text containing the text to find / column number, [specify the character number to start searching])
The FINDB function syntax has the following arguments:
Text to find / column number (required): The text or column number to find.
Text containing the text to find / column number (required): The text or column number that contains the text to find.
Specify the character number to start searching (optional): Specify the character from which to begin searching. If omitted, it is assumed to start from the first character.
Usage Example
Find the position of the values in column CU2 within column CU3 and write the results into column CU4.
FINDB(CU2, CU3)
