TEXTAFTER
Description
Returns text that occurs after the specified delimiting characters.
Syntax
TEXTAFTER(
text
, delimiter
,
[instance_num
], [match_mode
],
[match_end
], [if_not_found
])- text: The text to search. Worksheets doesn't support using wildcard characters in the search.
- delimiter: The text that marks the point after which you want to extract. The function returns the text that's located after this text.
- instance_num: The delimiter instance after which you want to extract the text. If you don't specify the argument, the default is 1. If you specify a negative number, the search starts from the end.
- 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 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: The value to return if the function doesn't find a match. By default, the function returns #N/A.
Example
The examples are based on this table. The example functions will return a worker's last
name using the space between the first and last names as the delimiter, and the last 4
digits of their Social Security number using the hyphen as the delimiter.
A | B | C | D | E | |
|---|---|---|---|---|---|
1
| Full Name
| First Name
| Last Name
| SS#
| Last 4
|
2
| Logan McNeil | 232-45-7667 | |||
3
| Steve Morgan | 611-33-5576 | |||
4
| Oliver Reynolds | 242-56-9755 | |||
5
| Teresa Serrano | 432-67-1442 |
Formula | Result |
|---|---|
=TEXTAFTER(A2," ") | McNeil
|
=TEXTAFTER(D2,"-",-1) | 7667
|