Excel REPLACE function

Function              REPLACE

Description        Excel REPLACE function replaces characters of a text specified by location in a given text string with another text string

Syntax  REPLACE(old_text, start_num, num_chars, new_text)

old_text  The text which is to be replaced.

start_num  The starting location in the text to be searched.

num_chars  The number of characters to be replaced.

new_text  The text which needs to be replaced with old_text.

Example: