Hi.
See here for some techniques:
Extracting numbers from a string 2: Consecutive numbers at end | EXCELXOR
Let me know if you need anything explaining.
Regards
HI there,
I wonder if there is any way that we can extract number from the right of a string, for example:
ABC123 => 123
ABCD$DE%34 => 34
Thank you very much!
Hi.
See here for some techniques:
Extracting numbers from a string 2: Consecutive numbers at end | EXCELXOR
Let me know if you need anything explaining.
Regards
Advanced Excel Techniques: http://excelxor.com/
thank you very much!
Rick's "mini" blog... http://www.excelfox.com/forum/f22/
.
Want to post a small screen shot? See Part B here.
Rick's "mini" blog... http://www.excelfox.com/forum/f22/
.
Want to post a small screen shot? See Part B here.
Ah, sorry. Didn't realise this was a VBA question!
Regards
Advanced Excel Techniques: http://excelxor.com/
Rick's "mini" blog... http://www.excelfox.com/forum/f22/
.
Want to post a small screen shot? See Part B here.
Like this thread? Share it with others