# TEXTAFTER

## Content

This function returns text that occurs after a given character or string.

## Syntax

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

## Arguments

The function has the following arguments:

| Argument | Description |
| -------- | ----------- |
| *text* | [Required] Refers to the text you are searching within. Wildcard characters are not allowed. |
| *delimiter* | [Required] Refers to the text that marks the point after which you want to extract. |
| *instance\_num* | [Optional] Refers to the instance of the delimiter after which you want to extract the text. <br>By default, instance\_num = 1. In case of a negative number, the text is searched from the end. |
| *match\_mode* | [Optional] Determines whether the text search is case-sensitive. The default is case-sensitive. You can enter one of the following:<ul><li>**0**      Case sensitive.</li><li>**1**      Case insensitive</li></ul> |
| *match\_end* | [Optional] Treats the end of the text as a delimiter. By default, the text is an exact match. You can enter one of the following:<ul><li>**0**      Don't match the delimiter against the end of the text</li><li>**1**      Match the delimiter against the end of the text</li></ul> |
| *if\_not\_found* | [Optional] Refers to the value returned if no match is found. By default, #N/A is returned. |

## Remarks

The TEXTAFTER function matches immediately when searching using an empty delimiter value. 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).

## Examples

`TEXTAFTER("Little red Riding Hood's red hood","red")` // result is "Riding Hood's red hood"
`TEXTAFTER("Little red Riding Hood's red hood","red", 2)` // result is "hood"
`TEXTAFTER("Little red Riding Hood's red hood","Red")` // result is #N/A
`TEXTAFTER("Little red Riding Hood's red hood","Red", ,1)` // result is "Riding Hood's red hood"