Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

SUBSTITUTE(text,old_text,new_text,instance_num) substitutes new text for old text in a text string

=SUBSTITUTE(A1, "you", "me")