Google Sheets 함수

REPLACE

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

이 함수는 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.

REPLACE

구문

인수

예시

자주 묻는 질문

관련 함수

REPLACE

구문

인수

예시

자주 묻는 질문

관련 함수