TEXTAFTER
Formulas / TEXTAFTERExtract text after a delimiter.
TEXT.AFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])
- text - required, the text to process
- delimiter - required, the string to use as a delimiter
- instance_num - [OPTIONAL] the nth occurrence of the delimiter in text
- match_mode - required, a boolean
- match_end - [OPTIONAL]
- if_not_found - [OPTIONAL]
Examples
=TEXTAFTER("Jones, Bob",",")The TEXTAFTER function can be used to extract the text after a given delimiter character. In the example above, the comma is the delimiter and the text that appears after it is "Bob".
=TEXTAFTER("Smith, John, 123 Main St",",")Let's say you have the text "Smith, John, 123 Main St". The TEXTAFTER function can be used to extract the text after the first comma, which would be "John". To do this, you would enter the above example and the result would be "John".
=TEXTAFTER("John, Smith, 123 Main St",",")You can also use the TEXTAFTER function to extract the text after the last delimiter in a string. For example, if you have the text "John, Smith, 123 Main St", you can use the TEXTAFTER function to extract the text after the last comma, which would be "123 Main St". To do this, you would enter the formula above and the result would be "123 Main St".
=TEXTAFTER("John Smith, 123 Main St"," ")The TEXTAFTER function can be used to extract text from any position in a string. For example, if you have the text "John Smith, 123 Main St", you can use the TEXTAFTER function to extract the text after the space, which would be "Smith". To do this, you would enter the formula above and the result would be "Smith".
Summary
The TEXTAFTER function is used to return text after a given character or string. It is the opposite of the TEXTBEFORE function and searches text from the end of a document. If the delimiter is not included, the function will return an #N/A error.
- The TEXTAFTER function takes six required arguments, and returns text that follows a delimiter.
Frequently Asked Questions
What is the TEXTAFTER Function?
What kind of data does the TEXTAFTER function return?
What is the syntax of the TEXTAFTER function?
What types of delimiters can be used with the TEXTAFTER function?
What happens if the delimiter is not found in the string?
What is the maximum length of text that the TEXTAFTER function can extract?
