RIGHTB Function in Excel: Syntax, Examples and Free Practice
RIGHTB is an Excel Text function. Like RIGHT, but counts bytes instead of characters — for double-byte languages.
RIGHTB syntax
Arguments
text: The text to work withnum_bytes: How many bytes to return (optional)
When to use RIGHTB
RIGHTB is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice RIGHTB online, free
Open the live Excel-style spreadsheet and try RIGHTB yourself. No Excel install or sign-up needed to start.
Practice RIGHTB now →More Text functions
Frequently asked questions
What does the RIGHTB function do in Excel?
Like RIGHT, but counts bytes instead of characters — for double-byte languages.
What is the syntax of RIGHTB in Excel?
The syntax is =RIGHTB(text, [num_bytes]). text: The text to work with; num_bytes: How many bytes to return (optional).
Where can I practice RIGHTB online for free?
Open the free live spreadsheet on Cellgrids and try RIGHTB 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