REPLACE function

REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string.

Syntax

REPLACE(old_text,start_num,num_chars,new_text)

Old_text     is text in which you want to replace some characters.

Start_num     is the position of the character in old_text that you want to replace with new_text.

Num_chars     is the number of characters in old_text that you want REPLACE to replace with new_text.

New_text     is the text that will replace characters in old_text.

Examples

Formula

Description (Result)

=REPLACE("abcdefghijk",6,5,"*")

Replaces five characters, starting with the sixth character (abcde*k)

=REPLACE("2009",3,2,"10")

Replaces the last two digits of 2009 with 10 (2010)

=REPLACE("123456",1,3,"@")

Replaces the first three characters with @ (@456)

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×