Remove Special Characters from Text using Excel VBA

Is an awesome video which helped me to solve my data, but found one issue here
After i've extracted the number, "ABCD 12385, 24685, 12545 & 35482", the outcome for the number is "12385246851254500000", the last group of number "35482" has become "00000"
Can help to solve the issue?
Thanks in advance.

Thank you very much!

Awesome video. I like it. Very useful.

May be you can also try to seperate odd even numbers as well?