"Find All" is showing wrong count

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")