"Find All" is showing wrong count

[faizzsheikh]

I have a range of data, this data includes articles with HTML codes. Each cell have one article and a total of 200 articles therefore 200 cells.


To explain in short, each cell have the word "<footer" in it. What I want to do is find the exact text "<footer" and replace it with, lets say any character "a" or "b" or whatever. But when I replace it only replaces 25 out 200, I am not sure what's wrong. Please help, I am badly stuck in this.


You can download the excel here by clicking on the "Slow Download" blue button.
find-replace.xlsx - Speedy Share - upload your files here

 

[martindwilson]

x post at
"Find All" is showing wrong count
nothing wrong with x-posting just provide the link
otherwise all the answers given here will just be a wasted effort of people on the other thread and vice versa