This is extremely unusual... I experimented with 3 different cells which was not finding "<footer". I kept picking pieces of content and find it until exactly from where excel is rejecting to find, and to my surprise one had a character "a" another a space " " and another a character "p"

How is this possible!