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