Google Sheets-Funktion

REPLACE

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

Formel mit KI erstellen Dieselbe Funktion in Excel

Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.

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.

Argumente

old_texterforderlichThe text string that contains the characters you want to replace.
start_numerforderlichThe position of the first character in old_text that you want to replace.
num_charserforderlichThe number of characters in old_text that you want to replace.
new_texterforderlichThe text that will replace the characters in old_text.

Beispiele

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

Ergebnis: 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.

REPLACE

Syntax

Argumente

Beispiele

FAQ

Verwandte Funktionen

REPLACE

Syntax

Argumente

Beispiele

FAQ

Verwandte Funktionen