VBA, remove all characters within a string, except numerical characters and full stops

I'm after a code that would remove all characters within a string that are not numbers (1234567890) and aren't full stops (.)


So lets say I have a string of text "ts [$11.40 USD]" (without quotes) in col F
Then after I would run the macro, it would only leave "11.40"
I'm looking for an easy and efficient code.

I have piece of code below that replaces "]" with blanks "". That is just an example that I would like to replace with something as described above.
Any help is very much appreciated. Any ideas?

Please Login or Register  to view this content.

Hey Rain,

I have this Link stored..

http://www.mrexcel.com/forum/excel-q...haracters.html
1. Remove Numeric characters
2. Remove Alphabetic characters
3. Remove Non-Numeric characters
4. Remove Non Alphabetic characters
5. Remove Non Alpha-Numeric characters
6. Remove Unprintable characters

Check if this may help you in advance... as a Quick

Maybe ...

Please Login or Register  to view this content.

Beatiful piece of code. It works like a charm. As I'm still learning and want to get better, can I leave some comments inside the code in terms of how I understand it. Am I more or less understanding it correctly?

Please Login or Register  to view this content.

Am I more or less understanding it correctly?

Yup, you got it.