Home › REPLACE

REPLACE in every language

TextLegacyLast verified 2026-11-04

LanguageNameSyntaxLibreOfficeSheets
EnglishREPLACEREPLACE(old_text, start_num, num_chars, new_text)——
GermanERSETZENERSETZEN(Alter_Text; Erstes_Zeichen; Anzahl_Zeichen; Neuer_Text)ERSETZENERSETZEN
FrenchREMPLACERREMPLACER(ancien_texte; no_départ; no_car; nouveau_texte)REMPLACERREMPLACER
SpanishREEMPLAZARREEMPLAZAR(texto_original; núm_inicial; núm_de_caracteres; texto_nuevo)REEMPLAZARREEMPLAZAR
Portuguese (Brazil)MUDARMUDAR(texto_antigo; núm_inicial; núm_caract; novo_texto)MUDARMUDAR
DutchVERVANGENVERVANGEN(oud_tekst; begin_getal; aantal-tekens; nieuw_tekst)VERVANGENVERVANGEN
ItalianRIMPIAZZARIMPIAZZA(testo_prec; inizio; num_caratt; nuovo_testo)RIMPIAZZARIMPIAZZA

Names and arguments from Microsoft Support; the LibreOffice and Google Sheets columns are those products' own localized names. Array-constant separators and localized error values are not yet covered.

Translate a formula with REPLACE