How to Use Excel LEN Function (Examples + Video)

Excel LEN Function (Example + Video)

Excel Len Function

When to use Excel LEN Function

LEN function can be used when you want to get the total number of characters in a specified string.

What it Returns

It returns a number that represents the number of characters in the specified string.

Syntax

=LEN(text)

Input Arguments

  • text – the string for which you want to find the number of characters. 

Additional Notes

  • Spaces are counted as characters.
    • To remove extra spaces from text strings, use the TRIM function.
  • It also works with numbers and treats numbers as text.
    • In case of numbers, formatting does not change the number of characters. For example, 1000 formatted as $1,000 would still return 3.

Excel LEN Function – Live Example

Excel LEN Function – Video Tutorial

Related Excel Functions:

You May Also Like the Following Excel Tutorials: