REPLACE function


DESCRIPTION:

This function returns the second argument if the condition is met, otherwise it returns the third argument.

 

SYNTAX:

=REPLACE( old_text, start_num, num_chars, new_text )

 

REQUIRED ARGUMENTS:

old_text

The text string to replace.

start_num

Starting position.

num_chars

The number of characters to replace.

new_text

The text used to replace the specified portion of the old text.