REPLACE, REPLACEB in other languages:



privacy

The Excel function: REPLACE, REPLACEB

Description

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.

 Important   REPLACE is intended for use with languages that use the single-byte character set (SBCS), whereas REPLACEB is intended for use with languages that use the double-byte character set (DBCS). The default language setting on your computer affects the return value in the following way:

The languages that support DBCS include Japanese, Chinese (Simplified), Chinese (Traditional), and Korean.



REPLACE, REPLACEB