Corrupted cells when creating .csv

[michwdmn]

I've been trying to convert several excel tables to .csv format for use in a GIS program.

Each time I do this, certain cells in essential column (which is used to join the .csv table to spatial data) get corrupted. The column contains UIDs that are numerical. The corruption places either a ? or another symbol at the beginning or the end of the UID. It does this only with certain cells and I cannot see any pattern. (See attached image for example of how the table looks, including one of the corrupted cells).

I have also tried saving the table to .csv by first saving it as .txt then replacing the tabs with commas in notepad, but I get the same problem.

Any help would be greatly appreciated.

Thanks.

 

[Special-K99]

Is this web related? That character could be CHAR(160).
You need to ascertain the ASCII code of that extra character.