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 →