Returns the text that occurs after a given delimiter.
Cú pháp
TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])Đối số
textbắt buộc
The text string containing the data you want to extract.
delimiterbắt buộc
The character or sequence of characters that marks the point after which to extract.
instance_numtùy chọn
The instance of the delimiter after which to extract text (defaults to 1).
The TEXTAFTER function extracts a substring from a text string that appears after a specified delimiter. It is highly useful for parsing data like email addresses or file paths where you need to isolate specific segments.
=TEXTAFTER("Excel-is-great", "-")→is-greatExtracts everything after the first hyphen.
=TEXTAFTER("Excel-is-great", "-", 2)→greatExtracts everything after the second hyphen.
Select the cell
Click on the cell where you want the result to appear.
Enter the formula
Type =TEXTAFTER( and provide the text string and the delimiter.
The function will return a #N/A error unless the if_not_found argument is specified.