Fonction Google Sheets

REPLACE

Replaces part of a text string with a different text string based on the number of characters you specify.

Générer une formule avec l'IA La même fonction dans Excel

Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.

Syntaxe

REPLACE(old_text, start_num, num_chars, new_text)

The REPLACE function is used to swap a specific portion of a text string with new text. It is particularly useful for cleaning data or formatting strings by targeting character positions rather than specific content.

Arguments

old_textobligatoireThe text string that contains the characters you want to replace.
start_numobligatoireThe position of the first character in old_text that you want to replace.
num_charsobligatoireThe number of characters in old_text that you want to replace.
new_textobligatoireThe text that will replace the characters in old_text.

Exemples

=REPLACE("2023-01", 1, 4, "2024")

Résultat : 2024-01

Replaces the first 4 characters ('2023') with '2024'.

FAQ

What is the difference between REPLACE and SUBSTITUTE?

REPLACE swaps text based on position, while SUBSTITUTE swaps text based on matching content.

Fonctions associées

SUBSTITUTE LEFT RIGHT MID