03-09-2011, 10:13 AM
Instead of using Split, you can also use Replace function.
Eg.
You can get 4500, by replacing unwanted characters by empty string "".
Eg.
Code:
myVar="Rs.4500/-"
myVar=Replace(myVar,"Rs.","")
myVar=Replace(myVar,"/-","")
msgbox myVar