Removing Unwanted Characters And Spaces From Text - Excel Tips

Hi Folks,
In this posting we are going to find out how to use an excel formula to remove the unwanted characters and spaces from a text.
Formula is available in the attached file. Go through it and let me know your thoughts..

Hi,
Really helpful.... as most of the times the characters or spaces come when converting the same from a different software.... Especially for a person like me handling huge data, this is like a magic wand....
Thanks for sharing...
Regards,
Ashutosh Thakre

Really a great job. It is also very useful for me. I was totally unknown to all these tricks. Nice work.
Keep Posting...........
Thanks & Regards
Dinesh Kumar