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