LENB Function in Excel: Syntax, Examples and Free Practice
LENB is an Excel Text function. Like LEN, but counts bytes instead of characters — for double-byte languages.
LENB syntax
=LENB(text)
Arguments
text: The text to work with
When to use LENB
LENB is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice LENB online, free
Open the live Excel-style spreadsheet and try LENB yourself. No Excel install or sign-up needed to start.
Practice LENB now →More Text functions
Frequently asked questions
What does the LENB function do in Excel?
Like LEN, but counts bytes instead of characters — for double-byte languages.
What is the syntax of LENB in Excel?
The syntax is =LENB(text). text: The text to work with.
Where can I practice LENB online for free?
Open the free live spreadsheet on Cellgrids and try LENB yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Text functions · Excel case studies · Excel tutorials · Excel shortcuts