Returns the text which follows a delimiter in a text string. TEXTAFTER ("first-second", "-") TEXTAFTER ("first-second"; "-") returns "second", the text which follows the first occurrence of the delimiter "-".

Use the third parameter to pick another occurrence of the delimiter. A negative number counts from the right, meaning that TEXTAFTER ("Ada Maria Lovelace", " ", - 1) TEXTAFTER ("Ada Maria Lovelace"; " "; - 1) returns "Lovelace", the last name. Counting from the right is often what you want, as the text you are looking for tends to follow the last delimiter.

Handling text strings without the delimiter

If the delimiter does not appear in the text string — or appears fewer times than the third parameter requires — an #N/A error is returned. Give the fourth parameter to return a value of your choosing instead:

This formula returns "not found" instead of an error.

Matching is case-sensitive

The delimiter must match exactly, including its case. Use the LOWER or UPPER functions to match regardless of case, by converting both the text string and the delimiter to the same case.

Use TEXTSPLIT to get every part of a text string instead of the text on one side of a delimiter. Use REGEXEXTRACT when the text to find is better described by a regular expression than by a literal delimiter. Use TEXTBEFORE to get the text which precedes the delimiter.