=RIGHTOFLAST
The RIGHTOFLAST Function returns text to the right of the specified characters (or words) in a string.
Syntax
Section titled “Syntax”=RIGHTOFLAST(ReturnRightOf; SearchInString)-
ReturnRightOf: The function will return the characters to the right of the last occurrence of this character(s)
-
SearchInString: The function will search within this string
The function above will return the word sloth because it is to the right of the last occurrence of the search term brown.