Google Sheets-funktion

REPLACE

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

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

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.

Argument

old_textobligatorisktThe text string that contains the characters you want to replace.
start_numobligatorisktThe position of the first character in old_text that you want to replace.
num_charsobligatorisktThe number of characters in old_text that you want to replace.
new_textobligatorisktThe text that will replace the characters in old_text.

Exempel

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

Resultat: 2024-01

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

Vanliga frågor

What is the difference between REPLACE and SUBSTITUTE?

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

Relaterade funktioner

SUBSTITUTE LEFT RIGHT MID