Hello
Well, the title says it all. I have cells with text and a number. If this number is 7 or 8 digits long I wish to extract it, if it's shorter or longer I do not wish to extract it.
There are no spaces between digits in a number.
I struggle to make it exclude longer numbers.
My current attempt:
Oh, maybe I should add, this is me learning RegEx. I could easily solve this with just VBA and no RegEx but today RegEx is on the menu.
Please Login or Register to view this content.
Last edited by Jacc; 08-15-2021 at 05:58 PM.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Try this. You do not need regout or x2.
Tested with your data.Please Login or Register to view this content.
Last edited by 6StringJazzer; 08-15-2021 at 07:15 PM. Reason: fixed errors in code
File attached
If you also have data like
1234567abc
a12345678
Please Login or Register to view this content.
Very impressive, thank you guys! RegEx code is hard to read for a novice but very cool!
Jindon you are right, I do indeed have data like that. I should have put together better sample data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks