I scraped data from a website that contains a half-million records to an Excel file. My problem is one column stores Arabic characters, and I can't apply any formatting to these cells while they contain a RIGHT-TO-LEFT MARK. I don't know it is a RIGHT-TO-LEFT MARK, but I copied the character from the cell (I can't see it) and converted it to ASCII, and got
(226 128 143). I searched for this code and I found "RIGHT-TO-LEFT MARK".
I tried to find a way to search the Excel sheet by ASCII code, but I couldn't find anything.
I'm using Excel version 15.27 on Mac El Capitan.
How can I remove this character from the whole column?