A to Z of Excel Functions: The LEN Function

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the LEN function.

The LEN Function

The LEN function returns the number of characters in a text string.  It employs the following syntax to operate:

The LEN function has the following argument:

• text: this is required and represents the text string whose length you wish to ascertain.

It should be further noted that:

• spaces count as characters in text.

Please see my examples below:

We’ll continue our A to Z of Excel Functions soon. Keep checking back – there’s a new blog post every business day.

A full page of the function articles can be found here.