Excel Function

LEN

Returns the number of characters in text.

LEN(text)

Arguments

text

Required

Enter a text value (wrap with quotes when needed).

Practice Preview

format and display text values. Use LEN to Returns the number of characters in text. use B2 for text. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=LEN(B2)

Practice This Function

Practice in Sequential Mode Back to Function List