Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Windows: 2208 (Build 15601)
Mac: 16.65 (Build 220911)
Web: introduced 15-Sep-2022
iOS: 2.65 (Build 220905)
Android: 16.0.15629

Returns text that occurs after given character or string. It is the opposite of the TEXTBEFORE function.


=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. Optional.


When searching with an empty delimiter value, TEXTAFTER matches immediately. It returns the entire text when searching from the front (if instance_num is positive) and empty text when searching from the end (if instance_num is negative).  



=TEXTAFTER("Red riding hood’s, red hood", "hood")

’s, red hood

=TEXTAFTER("Red riding hood’s, red hood", "")

Red riding hood’s, red hood

=TEXTAFTER("Red riding hood’s, red hood", "", -1)


  • Excel returns a #N/A error if delimiter isn't contained in text.

  • Excel returns a #VALUE! error if instance_num = 0 or if instance_num is greater than the length of text.

  • Excel returns a #N/A error if instance_num is greater than the number of occurrences of delimiter.


Copy the example data in each of the following tables and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.


Little Red Riding Hood's red hood

Little red Riding Hood's red hood




 Riding Hood's red hood






 Riding Hood's red hood






Marcus Aurelius


Immanuel Kant



=TEXTAFTER(A2," ",,,1)


=TEXTAFTER(A3," ",,,0)


=TEXTAFTER(A3," ",,,1)

=IF(TEXTAFTER(A3," ",,,1)="",A3)


=TEXTAFTER(A4," ",,,1)


See Also

Text functions (reference)


TEXTSPLIT function

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?

Thank you for your feedback!