RINSTR

Use to find the last occurrence of a string within another string

This function will give the last instance of a string within another string searching from the left hand side of the string. To use this function the format needs to be

RINSTR (target text,search text)

Here we are searching for the string RED within the string BLUE GREEN RED RED. Here is the formula as entered with the String radio button selected.

=RINSTR(RED,"BLUE GREEN RED RED") which gives the answer 16

This would put the following formula in the input field once the dialog was dismissed via OK

=STR(RINSTR(RED,"BLUE GREEN RED RED"))

If the text is not found the function returns a value of 0.

Any text containing spaces needs to be contained within "".

The function is case sensitive so the following would return a value of 0.

=STR(RINSTR("BLUE GREEN RED RED",Red))