Hi All
I am using this Function in my Sub:
It Strips the Numbers From a String BUT only when the String is in the format of Example : STP001 It would give me : STP![]()
Please Login or Register to view this content.
This is Great and works fine BUT
What if my String was STP001V I would like the result to be also : STP but because it has Letters on the end the Function Returns : ""
Any Ideas how i can Modify this Part:
Any Help is greatly appreciated.![]()
Please Login or Register to view this content.
Regards
JRidge
Bookmarks