LEN, LENB function

Category: Text
Introduced: Excel 2003

Summary

Returns the number of characters in a text string

Syntax

LEN(text) The LEN function's syntax has the following arguments:
• Text Required. The text whose length you want to find. Spaces count as characters.

Example

=LEN(B1)
=LEN(B2)
=LEN(B3)

Microsoft Support Page

https://support.microsoft.com/en-us/office/len-function-29236f94-cedc-429d-affd-b5e33d2c67cb

Back to Functions