This article describes the formula syntax and usage of the REPLACE and REPLACEB function in Excel.
REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string.
REPLACEB replaces part of a text string, based on the number of bytes you specify, with a different text string.
REPLACE always counts each character, whether single-byte or double-byte, as 1, no matter what the default language setting is.
The languages that support DBCS include Japanese, Chinese (Simplified), Chinese (Traditional), and Korean.
REPLACE(old_text, start_num, num_chars, new_text)
REPLACEB(old_text, start_num, num_bytes, new_text)
The REPLACE and REPLACEB function in excel syntax has the following arguments: