Formula Library

LEN

text

Returns the number of characters in a text string.

Syntax

=LEN(text)

Example

Excel
=LEN(A2)

Returns the total number of characters (including spaces) in the text in A2.

Tips & Notes

  • →Counts spaces and special characters
  • →Use with TRIM to remove extra spaces first
  • →Useful for data validation and text parsing

See Also

LEFTRIGHTTRIM

Need a custom LEN formula?

Describe exactly what you need and get the formula generated instantly.

Generate →

We use cookies and display ads via Google AdSense to keep ExcelBossPro free. Privacy Policy. By continuing, you accept our use of cookies.