Home › Functions › Text › REPLACEB
fx
REPLACEB
Text  ·  Since: Excel 2003  ·  9 languages

REPLACEB replaces part of a text string, based on the number of bytes you specify, with a different text string, for use with double-byte character set (DBCS) languages.

🌐 Translations

English REPLACEB
Deutsch ERSETZENB
Français REMPLACERB
Español REEMPLAZARB
Italiano SOSTITUISCI.B
Português SUBSTITUIRB
Nederlands VERVANGENB
Polski ZASTĄP.B
Русский ЗАМЕНИТЬБ

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

REPLACEB(old_text,start_num,num_chars,new_text)

Arguments

old_text (required) — Text in which you want to replace some characters.
start_num (required) — The position of the character in old_text that you want to replace with new_text.
num_chars (required) — The number of characters in old_text that you want REPLACE to replace with new_text.
new_text (required) — The text that will replace characters in old_text.

Related functions

Copied to clipboard