How to remove invisible character

I have had this issue a few times, specially when you export data from ERPs etc. There is a simple solution to fix this. First Select the data range you need to clean up. Then open"Find & Select -> Go to Special". (Keyboard shortcut -> Alt-H-F-D-S). Select the radio button against constants. Now there will be four boxes below ticked. Numbers, Text, Logicals, Errors. Just untick numbers and click ok. Now all the invisible and ghost characters containing cells would be highlighted. Just press delete and you are good to go. All the invisible chars are removed now.