Returns the text that occurs after a given delimiter.
구문
TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])인수
text필수
The text string containing the data you want to extract.
delimiter필수
The character or sequence of characters that marks the point after which to extract.
instance_num선택
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.