LENB Function Explained

The LENB Function in Microsoft Excel returns the number of characters in a text string, counting double-byte characters as 2 and single-byte characters as 1. It takes one argument, a text string, and returns the length of the string as a number.

LENB Function Syntax

LENB(text)

  • text: The text for which you want to know the number of characters, including any spaces.