How to delete text in Excel
A free Office suite fully compatible with Microsoft Office
Assume you have a workbook that you do regular updates to. You add new information, edit some existing data, remove old entries, etc. But what happens when you accidentally delete a column of text or if you want to clear some text for formatting purposes? This is why it's essential to know how to delete text in Excel.
Have you ever needed to delete all the text in an Excel worksheet except one word? Or maybe you've wanted to delete all of the numbers in a specific column but not the labels that appear to the left of those numbers. Whatever it is, there are multiple ways to delete text in Excel. In this tutorial, I'll show you three different ways to do it.
Tips that are provided in this article are compatible with versions 2010/2013/2016
How to delete text in Excel: Using Find and Replace
1.The first way to delete text from a cell is by using Find and Replace option.
2.To use Find and Replace, press Ctrl+H to display the Find and Replace dialog box. In the Find What box, enter the text you want to delete. In the Replace With box, enter an empty string ( ), as shown below:
3.You can now either click Replace All (which will replace all occurrences) and will leave the cells empty
That’s how you can delete text in excel using the find and replace option.
How to delete text in Excel: Using the Manual option
Well, we all know this way, select the text and press backspace, and your text will be clear. For example
1.You want to delete just a text from one cell.
2.Then there is no need to use formulas or the find and replace method.
3.Just select the cell and press backspace; your job will be done in seconds.
How to delete text in Excel: Mass Delete
There are several ways to do this if you have a lot of data in a spreadsheet and want to remove some of it. You can use the Delete key on your keyboard or press Backspace to remove one character at a time from any cell. However, if there are several cells with similar data, it may take some time to delete them all individually. This is especially true if you’re deleting column A or row 1 — those rows contain formulas that will cause problems if they are deleted.
To speed up this process, Excel has an easy-to-use mass delete feature that allows you to remove entire rows or columns with just one click quickly. You don’t even need to know where those rows or columns begin or end because the program automatically does all of that work for you!
1. Select your data and in tools, search for delete rows.
2.Press enter and it will delete all of that data.
3. That’s how to mass delete text in excel.
Did you learn how to delete text in Excel? You can follow WPS academy to learn more features of Word documents, Excel Spreadsheets, and PowerPoint slides.
You can also download WPS Office to edit word documents, Excel Spreadsheets, and PowerPoint free of cost. Download Now! And get an enjoyable working space.
Was this helpful?
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. How to compare two excel sheets and highlight differences
- 3. Check if value is in list in Excel (3 easy methods)
- 4. How to copy file names in Excel from a folder?
- 5. How to color cell based on value in Excel?
- 6. How to add month name from date in Excel formula