TEXTAFTER function
Summary
Returns text that occurs after given character or string
Syntax
TEXTAFTER(text,delimiter,[instance_num], [match_mode], [match_end], [if_not_found])
The TEXTAFTER function syntax has the following arguments:
text The text you are searching within. Wildcard characters not allowed. Required.
delimiter The text that marks the point after which you want to extract. Required.
instance_num The instance of the delimiter after which you want to extract the text. By default, instance_num = 1. A negative number starts searching text from the end. Optional.
match_mode Determines whether the text search is case-sensitive. The default is case-sensitive. Optional. Enter one of the following:
• 0 Case sensitive.
• 1 Case insensitive.
match_end Treats the end of text as a delimiter. By default, the text is an exact match. Optional. Enter one of the following:
• 0 Don't match the delimiter against the end of the text.
• 1 Match the delimiter against the end of the text.
if_not_found Value returned if no match is found. By default, #N/A is returned. Optiona
text The text you are searching within. Wildcard characters not allowed. Required.
delimiter The text that marks the point after which you want to extract. Required.
instance_num The instance of the delimiter after which you want to extract the text. By default, instance_num = 1. A negative number starts searching text from the end. Optional.
match_mode Determines whether the text search is case-sensitive. The default is case-sensitive. Optional. Enter one of the following:
• 0 Case sensitive.
• 1 Case insensitive.
match_end Treats the end of text as a delimiter. By default, the text is an exact match. Optional. Enter one of the following:
• 0 Don't match the delimiter against the end of the text.
• 1 Match the delimiter against the end of the text.
if_not_found Value returned if no match is found. By default, #N/A is returned. Optiona
Example
=TEXTAFTER(A2,"Red")
=TEXTAFTER(A2,"basket")
=TEXTAFTER(A3,"red",2)
=TEXTAFTER(A3,"red",-2)
=TEXTAFTER(A3,"Red",,FALSE)
=TEXTAFTER(A2,"red",3)
=TEXTAFTER(A2,"basket")
=TEXTAFTER(A3,"red",2)
=TEXTAFTER(A3,"red",-2)
=TEXTAFTER(A3,"Red",,FALSE)
=TEXTAFTER(A2,"red",3)