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