Excel REPLACE Function / Formula Examples + FREE Video

Excel REPLACE Function (Examples + Video)

Old_text    Required. Text in which you want to replace some characters.

Start_num    Required. The position of the character in old_text that you want to replace with new_text.Num_chars    Required. The number of characters in old_text that you want REPLACE to replace with new_text.New_text    Required. The text that will replace characters in old_text

Syntax

=REPLACE(old_text, start_num, num_chars, new_text)

Leave a Comment