Thanks Pike for the reply.
However I think the example I gave has some flaw. Thing is, the number i need to extract doesn't always come with SN# - SN# before it, sometimes it's just SN# followed by 9 digits.
So am I right to say in this case, regular expression is still a better way of doing it? I mean it does exactly what I need, detecting a pattern of SN# \d{9}, and return the 9 digits.
But I do have a question, is it possible to incorporate the user-defined function, as provided by Nilem, into my Sub instead? I have tried to do some research and I believe I should do something as follow:
I am not sure what comes after that, if I need to search the string in column D, and return the 9 digits in column E.
Bookmarks