*39*

You can use the following formulas to remove specific substrings from cells in Google Sheets:

**Method 1: Remove One Substring from Cell**

=SUBSTITUTE(A2,"this_string","")

**Method 2: Remove Multiple Substrings from Cell**

=SUBSTITUTE(SUBSTITUTE(A2,"string1",""),"string2","")

The following examples show how to use each of these methods in practice.

**Note**: These formulas “remove” substrings from cells by substituting specific substrings with blanks.

**Method 1: Remove One Substring from Cell**

Suppose we have the following dataset that contains information about various basketball teams:

We can use the following formula to remove the substring “Team” from each cell in column A:

=SUBSTITUTE(A2,"Team","")

We’ll type this formula in cell **C2** and drag and fill it down to each remaining cell in column C:

Notice that the substring “Team” has been removed from each cell.

**Method 2: Remove Multiple Substrings from Cell**

Suppose we have the following dataset that contains information about various basketball teams:

We can use the following formula to remove the substrings “Team” and “Name” from each cell in column A:

=SUBSTITUTE(SUBSTITUTE(A2,"Team",""),"Name","")

We’ll type this formula in cell **C2** and drag and fill it down to each remaining cell in column C:

Notice that the substrings “Team” and “Name” have been removed from each cell.

**Note**: You can use as many nested **SUBSTITUTE** functions as you’d like to remove as many substrings from cells as you’d like.

**Additional Resources**

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

How to Extract Substring in Google Sheets

How to Reverse a Text String in Google Sheets

How to Extract Numbers from String in Google Sheets