REPLACE function

Category: Text functions

What does this function do?

Replaces part of a text string with a different text string.

Syntax:

REPLACE(old_text,start_num,num_chars,new_text)

• Old_text:text in which you want to replace some characters.
• Start_num: 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:

=REPLACE(“0123456789″, 2, 7,”CH”) = 0CH89
=REPLACE(“El sabio de Excel”, 10, 2, 42) = El sabio 42 Excel

If A1=”El sabio de Excel”

=REPLACE(A1, 10, 2, 42) = El sabio 42 Excel