A user had exported a .csv from our online db and when she opened the document in Excel 2007 it had the "question-mark-in-the-box" special character between each word (the place where a space would be) in most, but not all rows.
My question is how to remove this special character from the entire document.
The =Code function revealed the special character to be 117.
I opened, Find and Replace, alt+0117 (only using keypad) which resulted in "u" in the Find line. I hit a space in the Replace line, but Excel didn't find any "u"...
Sorry about that I realized that the special character is at the eleventh position, which then reveals special character code 9. When I use ALT+09 nothing gets entered into the Find line, when I use ALT+9 another character comes up (that is not in the row).