TEXTAFTER

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

Syntax

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.

Any of the optional arguments can be omitted. An optional argument requires all preceding separators to be present.

Example:

=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.

Technical information

This function is available since LibreOffice 25.8.

This function is NOT part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.TEXTAFTER