Table of Contents
One can easily remove a substring in Google Sheets by using the “Find and Replace” function. This function allows the user to specify the substring they want to remove and replace it with a blank space, effectively eliminating it from the sheet. This can be done by selecting the desired cells, clicking on “Edit” and then selecting “Find and Replace.” From there, the user can enter the substring they wish to remove and leave the “Replace with” field blank. This simple process allows for the quick and efficient removal of unwanted substrings in Google Sheets.
Remove Substring in Google Sheets (With Example)
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.
Cite this article
stats writer (2024). How do I remove a substring in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-remove-a-substring-in-google-sheets/
stats writer. "How do I remove a substring in Google Sheets?." PSYCHOLOGICAL SCALES, 26 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-remove-a-substring-in-google-sheets/.
stats writer. "How do I remove a substring in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-remove-a-substring-in-google-sheets/.
stats writer (2024) 'How do I remove a substring in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-remove-a-substring-in-google-sheets/.
[1] stats writer, "How do I remove a substring in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I remove a substring in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.