TEXTAFTER

Formulas / TEXTAFTER
Extract 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?
The TEXTAFTER function is a function that extracts text after a delimiter character. It returns a single value.
What kind of data does the TEXTAFTER function return?
The TEXTAFTER function returns a single value.
What is the syntax of the TEXTAFTER function?
The syntax of the TEXTAFTER function is TEXTAFTER(string, delimiter).
What types of delimiters can be used with the TEXTAFTER function?
The TEXTAFTER function can be used with any type of delimiter, including a space, comma, or period.
What happens if the delimiter is not found in the string?
If the delimiter is not found in the string, the TEXTAFTER function will return an empty string.
What is the maximum length of text that the TEXTAFTER function can extract?
The TEXTAFTER function can extract up to 255 characters of text.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV