Hi i have a large database (70,000 lines +) which I have exported into Excel from Access, one of the columns contains notes about that data row, in particular some say QUERY where the data is suspect. Before i do any analysis of my data I wish to delete these rows however the word QUERY does not appear in the filter drop down for that column. Any suggestions as to why this may be the case? I assume that it is something to do with formatting, although I went back to the database and created an addional column and again identified the same rows as "Q" and once again after exporting the database the new column would not filter for "Q".

Any help would be much appreciated.