Excel Magic Trick 489: Extract Only Numbers From Text String Array Formula
See an amazing Array Formula from Domenic and Ron Coderre at the Mr Excel Message Board that extracts only the numbers from a text string. See the functions LEN, INDIRECT, ROW, MID, ISNUMBER, INDEX, LARGE, SUMPRODUCT, and SUM.
I agree, it is one of the cooler and more complicated formulas that I gleaned from the Mr Excel Message Board…
You are welcome!
But I have to say that when I encounter some of the formulas from the MVPs at the Mr Excel Message Board, it takes me hours of examining the different aspects of the formulas until I see the logic of how the formula works. This one took me a while before I could see how it worked.
Really, it does not matter what level of Excel you are at, it usually takes a while to see the logic. But once you do it is like eating candy, or tofu (I like tofu)).
Wow! I have to say, of all the formulas I’ve learned from you, this one takes the cake. Just amazing…
Mike, your way of unfolding these megaformulas is truly amazing. These video tutorials are so informative, that it would have taken hours of struggle had it been left to just learn it purely from some textbooks. Watching your videos now, make the process of learning from books and website a breeze! Thanks again!
That is a pretty hard formula, right? But if you know what each formula element does and a bit of math, it works just fine!
Wonderful
Strange but true!
Yes, the upper end of Excel is really cool!!
this is freaky