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.

Now, it's time to make Excel count how many of each animal there are in your original table, and this is where using the hash sign makes life a lot easier. To do this, you'll need ...