Hey Ron! yes indeed so with a Reference like ABC1234567. The first remove statement takes the first 3 characters "ABC" and it removes charcters that are in "A" to "Z" in this case all three are in the range so the result = "" (blank). TRUE. If we put JaMeS into it it would have returned "a" and that would be "" so false.
BTW , how about a follow up on the nested custom functions, there's not much out there, also i must get Ricks and what's her names book. I think you and he should to a video together, it would be an interesting contrast in style. 😋😋
Ye that would be great idea - that book is next level. They really went all out with that one. Might be a good collab! and thanks for that content idea on nested custom functions! was wondering what to do next :)
Great videao
Ok, I may have only been following along, and just about understand the logic, but oh, the sense of amazement when I clicked ok and it worked. 😊😊
Glorious!
Awesome Video
Thanks!
Enjoyed the video, some interesting steps.
thanks Tony!
Love these videos, keep them coming!
I’m not sure when I’d use this, but another great video.
Can you please explain the 2 Text.remove statements?
Hey Ron! yes indeed so with a Reference like ABC1234567. The first remove statement takes the first 3 characters "ABC" and it removes charcters that are in "A" to "Z" in this case all three are in the range so the result = "" (blank). TRUE. If we put JaMeS into it it would have returned "a" and that would be "" so false.
so it returns a TRUE of the characters match. if it doesnt match then it returns FALSE and it's not part of the pattern.
Another great video 👍. Thanks James
thank you!
Life saver
Una maravilla de Función 🎉🎉🎉🎉❤❤❤
👏
Most excellent!
Super
BTW , how about a follow up on the nested custom functions, there's not much out there, also
i must get Ricks and what's her names book. I think you and he should to a video together,
it would be an interesting contrast in style. 😋😋
Ye that would be great idea - that book is next level. They really went all out with that one. Might be a good collab! and thanks for that content idea on nested custom functions! was wondering what to do next :)
Great !
It is easier and faster with REGEXEXTRACT function in excel using the pattern "[A-Z]{3}[0-9]{7}"
how do you extract a a number pattern with "/" and number (eg. 1234554/1, 1334535/2) using your example?