How to delete special characters in excel?
- LinkBack URL
- About LinkBacks
- Show Printable Version
- Subscribe to this Thread…
Rate This Thread
- Linear Mode
- Switch to Hybrid Mode
- Switch to Threaded Mode
Remove Special Characters
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.
Last edited by bkatzman; 04-13-2010 at 11:51 AM .
Re: Remove Special Characters
First find out what Character code it is.
=Code(Mid(a1,4,1)) where A1 contains a sample string with that character at the 4th position.
After you find out the code.
Then go to Edit|Replace
In the Find what box: Hold the ALT key down and enter a 0 (zero) and the code only using the numeric key pad.
In the Replace With box: enter a space with the spacebar
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.