ƒxPlainFormulaThink in English. Formula in Excel.

FUNCTION CATALOGUE / TEXT

TEXTAFTER Excel function

Returns text after a delimiter.

Correct sentence to use

Return the text after [delimiter] in [text].

Modify this query in PlainFormula →

Example formula

=TEXTAFTER(A2,"-")

Returns text after a delimiter.

Syntax

TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])

Argument signature: text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found]

Availability note

Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.

Check Microsoft's Excel function documentation ↗

← Browse all functions