REPLACE | excel replace text
ThisarticledescribestheformulasyntaxandusageoftheREPLACEandREPLACEB functioninMicrosoftExcel. Description REPLACEreplacespartofatextstring,basedonthenumberofcharactersyouspecify,withadifferenttextstring. REPLACEBreplacespartofatextstring,basedonthenumberofbytesyouspecify,withadifferenttextstring. Important: Thesefunctionsmaynotbeavailableinalllanguages. REPLACEisintendedforusewithlanguagesthatusethesingle-bytecharacterset(SBCS),whereasREPLACEBisin...
This article describes the formula syntax and usage of the REPLACE and REPLACEB function in Microsoft Excel.
DescriptionREPLACE 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:
These functions may not be available in all languages.
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:
REPLA...