REPLACE Function

The REPLACE function replaces a part of the text with a different text, based on the number of characters specified.

Formula:


=REPLACE(Original text, Start num, Num of characters, Text to be replaced)
Whereas the "Start num" is the position from where the text has to be replaced and the "Num of characters" is the number of characters to be replaced.

Video Tutorial:


Let us replace the content of the text, using the REPLACE function, with the help of the below video

Learn MS Excel


Ask Questions

Ask Question