Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

=SUBSTITUTE(A3, 1, 2, 1)

Input the formula: =SUBSTITUTE(A3, "1", "2", 1)