I have a spreadsheet with 7,000 lines and about 30 columns. This data is used to populate a database and is causing problems due to some of the fields containing an odd character. I am attaching a file with only a few examples. The highlighted cells contain the special character.
I have done enough research to learn that the character is seen by Excel as Char 63 or the question mark. It's just not visible. I have tried TRIM, REPLACE, SUBSTITUTE, as well as some specific code samples found throughout EE. No luck though. Any help would be greatly appreciated.