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.

Remove Text before or after a specific Character in Excel. ... Fix: Excel not auto calculating formulas. Remove the last few characters from a column of text.

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." ...

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.