You can use the TEXTAFTER function in Excel to extract all text in a cell after a specific character or substring.
This function uses the following syntax:
TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])
where:
- text: Text to search
- delimiter: Character or substring to extract text after
- instance_num (optional): Instance of delimiter after which to extract text (default is 1)
- match_mode (optional): 0 = case-sensitive (default), 1 = case-insensitive
- match_end (optional): Treat end of text as delimiter (disabled by default)
- if_not_found (optional): Value to return if delimiter is not found
The following examples show the most common ways to use this function with the following dataset in Excel:
Related: How to Extract Text Before a Character in Excel
Example 1: Extract Text After Substring
We can type the following formula into cell B2 to extract the text in cell A2 after the substring “is” is encountered:
=TEXTAFTER(A2, "is")
We can then click and drag this formula down to each remaining cell in column B:
Column B contains the text in column A after the substring “is” is encountered.
Example 2: Extract Text After First Space
We can type the following formula into cell B2 to extract the text in cell A2 after the first space is encountered:
=TEXTAFTER(A2, " ")
We can then click and drag this formula down to each remaining cell in column B:
Column B contains the text in column A after the first space is encountered.
Example 3: Extract Text After Nth Space
We can type the following formula into cell B2 to extract the text in cell A2 after the third space is encountered:
=TEXTAFTER(A2, " ", 3)
We can then click and drag this formula down to each remaining cell in column B:
Column B contains all of the text in column A after the third space is encountered.
Note: You can find the complete documentation for the TEXTAFTER function in Excel here.
Additional Resources
The following tutorials explain how to perform other common tasks in Excel:
Excel: How to Remove Specific Text from Cells
Excel: How to Remove Special Characters
Excel: How to Insert a Character into a String
