Forum Discussion
Help with forumla
Hi Sergi, I still seem to be having trouble removing all of the formula's.
In the attached extract I have not removed any formula's, when you click on a blank cell you can still see the formula even though there is no result.
If I highlight column E it will show a count of 9 as every cell has a formula.
If I copy and use paste special to paste only the values, the formula's are removed and the blank cells in column E show no formula however when I highlight the column again it is still counting 9. I assume there is something hidden there that I am having trouble removing.
What am I doing wrong?
Appreciate your help.
Formulas are returning some string or empty string "", thus all cells in the range have some text value. Empty string doesn't mean blank cell, that is the cell with text. If copy and paste as values, empty strings also will be pasted.
Excel counts them as cells which have some values, i.e. not empty.
Second formula counts the range ignoring empty strings.
Thus you need to remove all formulas, not copy/paste values they return.