@glenn kennedy

=SUBSTITUTE(A3,"<footer","|") this solves my problem! Thank you so much Glenn.

However, if its due to non printable character how can we fix it without using a formula?

God, I am out of trouble!!