TEXTAFTER

Returns the text that occurs after a given substring or delimiter.

TEXTAFTER( Text [; Delimiter [; Instance Number [; Match Mode [; Match End [; If Not Found ]]]]])

Text: the original text.

Delimiter: (optional) the delimiter. Multiple delimiters can be supplied.

Instance Number: (optional) the instance of the delimiter after which to extract text. The default is 1. A negative number starts searching from the end.

Match Mode: (optional) set to 1 to perform a case-insensitive match. The default is 0.

Match End: (optional) set to 1 to treat the end of text as a delimiter. The default is 0.

If Not Found: (optional) the value returned if no match is found. The default is #N/A.

=TEXTAFTER("To be or not to be";"or";1;0;0;"@@@") returns the string "not to be", taking after the delimiter "or".

=TEXTAFTER("To be or not to be";"question";1;0;0;"@@@") returns the text "@@@" because the delimiter "question" is not in the source text.

COM.MICROSOFT.TEXTAFTER