Please note javascript is required for full website functionality.


A to Z of Excel Functions: The LEN Function

17 September 2021

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.