Hi all,
Basically I want to split data into each cell just the number without alphabet and special character.
The data I want to split is:
a=1,995.000 b=2,001.000 c=1,994.000 d=1,996.000 e=1,281
Currently I have a set of code. New to regex, I need some help with the pattern.
The code work well with the above data. But cant split if the data doesn't have "," or ".".
ie, e=999. Search and trying a lot, I guess if the .pattern can be fixed then the code is complete.
The code is as below:
By Ab33
Please put the data in column K.
If you want to see attachment, it below.
http://www.mrexcel.com/forum/excel-q...ml#post3922941
Bookmarks