There are mainly two ways to remove the formula in Excel and keep the text. No matter how many formulas you have used in your spreadsheet, you can delete or hide them without removing the values.

Protected and unprotected cells look the same in a spreadsheet. To delete all unprotected cells, you must select all of them at once, which can be easily done by using the Find and Replace feature.

How to remove a password to unencrypt an Excel spreadsheet On a PC 1. Open your encrypted Excel spreadsheet, type in the password, and click "OK." ...