The FIND, SEARCH, REPLACE, SUBSTITUTE and EXACT Functions

THE FIND, SEARCH, REPLACE, SUBSTITUTE AND EXACT FUNCTIONS 

The following two functions are complementary REPLACE(fexf, sta rt n u m, num characters, new text) and SUBSTITUTE(fexf, old text, new text, lnstance num). 

REPLACE replaces unspecified characters at a specified position within a text string. Note that, except for the inclusion of a fourth argument, new text, its syntax is similar to that of the MID function. 

EXAMPLE if cell A1 contains the text 2001, REPLACE(A1, 3, 2, 02 ) returns 

SUBSTITUTE replaces specific characters within a string. For example, if cell A1 contains Et and cell B1 contains (C2H5) then SUBSTITUTE Et3N , A1, B1) returns the text (C2H5)3N. If the optional argument instance num is specified, only that instance of old text will be replaced. If instance num is omitted, all instances of old text will be replaced. 

---