REPLACE function takes four separatearguments.
The first argument,old_text, is the text string to be processed.
The second argument,start_numis the numeric position of the text to replace.
The third argument,num_chars,is the number of characters that should be replaced.
The last argument,new_text, is the text to use for the replacement.
Use theSUBSTITUTE functionto replace text by searching when the location is not known.
UseFINDorSEARCHto determine the location of specific text.
When the text is not found, FIND returns a #VALUE error.
