פונקציית Google Sheets

REPLACE

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

יצירת נוסחה עם בינה מלאכותית אותה פונקציה ב-Excel

פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-Excel — אותה תחביר ואותם ארגומנטים.

תחביר

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.

ארגומנטים

old_textחובהThe text string that contains the characters you want to replace.
start_numחובהThe position of the first character in old_text that you want to replace.
num_charsחובהThe number of characters in old_text that you want to replace.
new_textחובהThe text that will replace the characters in old_text.

דוגמאות

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

תוצאה: 2024-01

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

שאלות נפוצות

What is the difference between REPLACE and SUBSTITUTE?

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

פונקציות קשורות

SUBSTITUTE LEFT RIGHT MID