Please note javascript is required for full website functionality.

Blog

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:

LEN(text)

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.

Newsletter