You can use the following formula in Google Sheets to extract all text from a cell after a specific character:

=REGEXEXTRACT(A2,".*our(.*)")

This particular formula extracts all of the text in cell **A2** that occurs after the string “our” is encountered.

This formula uses the **REGEXTRACT** function to extract all characters **(.*)** after **our**.

The following example shows how to use this formula in practice.

**Example: Extract Text After Character in Google Sheets**

Suppose we have the following list of phrases in Google Sheets:

Now suppose that we would like to extract all text from each cell after the string “our” is encountered.

To do so, we can type the following formula into cell **B2**:

=REGEXEXTRACT(A2,".*our(.*)")

We can then click and drag this formula down to each remaining cell in column B:

Column B now displays all text after “our” for each phrase in column A.

To extract the text after a different specific character, we simply need to replace **our** with something else.

For example, we could type the following formula into cell **B2** to extract all text after “is ” from cell **A2**:

=REGEXEXTRACT(A2,".*is (.*)")

We can then click and drag this formula down to each remaining cell in column B:

Column B now displays all text after “is ” for each phrase in column A.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Google Sheets:

Google Sheets: Check if Cell Contains Text from List

Google Sheets: How to COUNTIF Not Equal to Text

Google Sheets: Conditional Formatting if Another Cell Contains Text