Trying to find and replace hidden characters in Excel 2011 for OSX, not succeeding

I have a document that has trailing spaces of some nature. I seem to have narrowed it down to the unicode &#202 which is called an E with a cricumflex. It is located as the last character of every cell, which was imported values from a webpage. I can get rid of it using =SUBSTITUTE(A1,CHAR(202),"") but I have over 100,000 cells to do this to, so creating new columns for this is not reasonable.

I am trying to use the find and replace option but am unable to make it work. I think the trouble is osx and typing the hidden character.

Can anyone help.

Again, this is on a mac, so I don't know if that differs from windows.


Thank you.

find and replace worked ok for me with that character - suggest you upload an example workbook (just put a few lines of data in, not the full thing).

If the problem is just typing in the character, put =char(202) in a cell and then copy that and paste it into the replace window.

Copying the =char(202) worked a treat.

Capital letters are intentional

THANK YOU THANK YOU THANK YOU

Screen Shot 2014-03-21 at 11.32.17 AM.png