Single Quote instead of Emtpy Field in CSV

Hey there. Anytime I have an empty field in my CSV, example:

"Bob","Cindy","","Greg"

The grid will display as such:
Bob | Cindy | ' | Greg

For some reason, it puts a single quote (') in the NULL fields. I've tried this with tab deliminated too, same results. I can't seem to get rid of the pesky little ' no matter what I do. I'm using IE. You can recreate the problem by deleting a field in the sample CSV file.

Is there anyway to fix this problem?

Yes... an empty/null field will display the single quote you mention. You can get rid of it by just putting a space between the 2 quotes " ".