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