Table of Contents
Removing specific text from cells in Excel can be done using the “Find and Replace” function. This function allows you to search for a specific word or phrase and replace it with a blank space, effectively removing it from the cell. To do this, select the cells containing the text you want to remove, then click on the “Find and Replace” button in the “Home” tab. In the “Find what” field, type in the text you want to remove. Leave the “Replace with” field blank and click on “Replace All”. This will remove all instances of the specified text from the selected cells. Alternatively, you can also use the “Find and Replace” function to replace the specific text with a different word or phrase.
Excel: Remove Specific Text from Cells
You can use the following basic formulas to remove specific text from cells in Excel:
Method 1: Remove One Specific Text
=SUBSTITUTE(A1,"text1","")
This particular formula removes “text1” from cell A1.
Method 2: Remove Multiple Specific Texts
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"text1",""),"text2",""),"text3","")
This particular formula removes “text1, “text2”, and “text3” from cell A1.
The following examples show how to use each method in practice.
Example 1: Remove One Specific Text
Suppose we have the following column in Excel that shows the position for 15 different basketball players:
We can use the following formula to remove “r” from every position name:
=SUBSTITUTE(A2,"r","")We can type this formula into cell B2 and then copy and paste it down to every remaining cell in column B:
Notice that the “r” has been removed from every position name.
Example 2: Remove Multiple Specific Texts
Suppose we want to remove the following specific text from each username:
- dashes (–)
- exclamation points (!)
- the number 5 (5)
We can use the following formula to do so:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"-",""),"!",""),"5","")
We can type this formula into cell B2 and then copy and paste it down to every remaining cell in column B:
Notice that any “-“, “!”, and “5” has been removed from every username.
Additional Resources
The following tutorials explain how to perform other common tasks in Excel:
Cite this article
stats writer (2024). How do I remove specific text from cells in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-remove-specific-text-from-cells-in-excel/
stats writer. "How do I remove specific text from cells in Excel?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-remove-specific-text-from-cells-in-excel/.
stats writer. "How do I remove specific text from cells in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-remove-specific-text-from-cells-in-excel/.
stats writer (2024) 'How do I remove specific text from cells in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-remove-specific-text-from-cells-in-excel/.
[1] stats writer, "How do I remove specific text from cells in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I remove specific text from cells in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.