A friend shared this challenge: extract the largest number from this text **as420lkjs09nsdk2324lkjsd099** ! The answer is **2324**. How do we solve this? Formulas? VBA? Continue reading

# Posts Tagged → array

# Video 00044 Array Formulas_Example2_EXACT LEFT_functions

**Question: Why use an array formula?**

**Answer: Y****ou can answer a complex question using only 1 array.**

In this video, the array uses the EXACT and LEFT worksheet functions. Continue reading

# Video 00043 Formulas_Array Formulas_Example1_LEN_function

**Question: Why use an array formula?**

**Answer: ****Because you can answer many complex questions using only 1 array formula!**

In this video, I use an array formula to extend the use of Excel’s LEN function. Continue reading