VBA Code to optimize and clean data - Remove spaces/dashes/plus/asterisk from numbers

Hey everyone!

Is there any simple VBA code that I can use to clean some column with numbers like this:
probii.png

I need to remove spaces, dashes (-), plus signs (+) and asterisks (*), only maintain the slash (/).

Thanks in advance

Hello JoaoVr,

Do you not want to just use the Find/Replace feature?

Thanks,

Rvasquez

Originally Posted by rvasquez

Hello JoaoVr,

Do you not want to just use the Find/Replace feature?

Thanks,

Rvasquez

I think it would work as also I'm having some trouble to delete some ' signals and some line breaks (Like someone pressed enter or something).

This webpage should help you find and replace the unknown.

http://support.microsoft.com/kb/214204
Thanks!