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.

The LEN function can normally only tell you the length of the contents of a single cell. However, an array formula can use the LEN function to determine the length of a range of cells.


Watch my YouTube video


Confused? Watch this Array Intro video


Buy the only Array formula Book!

Array formula book


Written by Mike Girvin from YouTube channel ExcelIsFun





Subscribe to my YouTube channel and learn more!

See my free templates here!

Leave a Reply

Your email address will not be published. Required fields are marked *