To remove formula in Excel and keep text using the keyboard shortcut, follow these steps: Open the spreadsheet on your computer. Use your mouse to select all cells or a range.

Start Excel. Click the "File" tab. Click "Open." Browse to the spreadsheet with highlighted text and double-click the XLS or XLSX file name. Scroll to the section with the highlight.

In this tutorial, we will explain how to delete text vertically in Microsoft Word or Excel, and it is quite easy. How to delete Text vertically in Word Launch Microsoft Word .

Remove text strings using Excel 2007's "Replace" command. Select all the cells in which you want to replace characters. In the "Editing" group on the "Home" tab, select "Replace." ...

Note: When you delete cells in Excel, the data below it will be moved up. 6. Once all the blank rows are highlighted, go to the Home tab and locate the Delete button on the right-hand side.