TEXTAFTER Function. Get substrings after a specified character (Microsoft Excel)
The TEXTAFTER function is a new function added to Excel in September 2022.
It specifies the character to search for and retrieves the text after that character.
This function is the reverse function of TEXTBEFORE.
Originally, you had to combine FIND and RIGHT, but now you only need one function. now only one function is needed.
How it works
=TEXTAFTER(Text,Delimiter,Instance_num,Match_mode,Match_end,If_not_found)
| Name | Omission | Explanation |
|---|---|---|
| Text | Required argument. Specify text. | |
| Delimiter | Required argument. Specify the characters to search for. Two or more characters are also acceptable. | |
| Instance_num | 1 | Specifies the number of Delimiter. If omitted, it is 1. Text is obtained up to the first Delimiter. If a negative number is specified, it is the number of pieces from the right. |
| Match_mode | 1 | Specifies whether to be case-sensitive. 0: Case sensitive. 1: Not case sensitive. |
| Match_end | 0 | 0: Performs a normal search. 1：The search is performed on the assumption that there is a delimiter at the end of the text. If there is no delimiter in the text, the full text is the first result. |
| If_not_found | #N/A | Specifies the result if the delimiter is not present. |
Demonstrate
Basically, the first argument specifies the text.
The second argument specifies the characters to be searched.
The second argument can be two or more characters.
Argument 3: Instance_num
The third argument specifies the number of Delimiter to be obtained.
If omitted, it is set to 1. Up to the first Delimiter.
If a negative number is specified, the number of pieces will be from the right.
Argument 4: Match_mode
The fourth argument specifies whether it is case-sensitive.
- 0: Case sensitive.
- 1: Not case sensitive.
If 1 is specified, the first result is the full text.
Argument 5: Match_end
The fifth argument specifies the search method.
Compared to the TEXTBEFORE function, this argument can be used in fewer situations than the TEXTBEFORE function.
If 1 is specified, the search assumes that Delimiter exists at the end of the text.
However, since there are no characters after the tail, the result will be blank.
If Delimiter is not found in 1, the result of -1 is the full text.
Argument 6:If_not_found
The sixth argument specifies the result if not found.
---