Google Sheets işlevi

REPLACE

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

Yapay zekâ ile formül oluştur Excel'deki aynı işlev

Bu işlev, Google E-Tablolar'da Excel'deki gibi çalışır — aynı söz dizimi ve bağımsız değişkenler.

Söz dizimi

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.

Bağımsız değişkenler

old_textzorunluThe text string that contains the characters you want to replace.
start_numzorunluThe position of the first character in old_text that you want to replace.
num_charszorunluThe number of characters in old_text that you want to replace.
new_textzorunluThe text that will replace the characters in old_text.

Örnekler

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

Sonuç: 2024-01

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

SSS

What is the difference between REPLACE and SUBSTITUTE?

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

İlgili işlevler

SUBSTITUTE LEFT RIGHT MID