SEARCHB Function
Returns the byte position of one text value inside another. Not case-sensitive, wildcards allowed.
Category
Text
Available in
All versions, Microsoft 365
Returns
A number (position)
Overview
SEARCHB is the “byte” version of SEARCH. It counts bytes instead of characters — but only when a double-byte language (Japanese, Chinese or Korean) is set as Excel's default editing language. Then each double-byte character counts as 2.
In every other setup, including English, SEARCHB gives exactly the same result as SEARCH. Unless you build workbooks for double-byte systems, use SEARCH.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| find_text | Yes | What to look for. ? and * are wildcards. |
| within_text | Yes | The text to search. |
| start_num | Optional | Where to start. Default 1. |
Examples
Example 1 — Finding a word
Where does “refund” start, whatever the capitals?
| A | B | |
|---|---|---|
| 1 | Ticket | Position |
| 2 | Please REFUND me | 8 |
| 3 | Refund #882 | 1 |
With English as the default language, =SEARCH("refund", A2) returns the same answers.
Common mistakes
- Results change with language settings. A workbook using SEARCHB can give different answers on a computer whose default language is Japanese, Chinese or Korean. Prefer SEARCH for workbooks you share.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.