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