"Find All" is showing wrong count

Originally Posted by newdoverman

Using =FIND("<footer",A3) and filling down, finds <footer in every record. To replace <footer with something else use SUBSTITUTE

Enter in B3 and copy down then copy and Paste Values to get rid of the formula.

Formula:

=SUBSTITUTE(A3,"<footer","your text")

I suggested that back at Post 3, but the OP seemed t want an alternative solution.