Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ € - € R$ - R$ € - € \ \- \ \- \ \- \ \- $ ($ ) $ ($ ) $ ($ ) $ ($ ) - - \ \ - \ - - - \ \ - \ - : : : : Lt - Lt kr - kr € - € SFr. SFr. - / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 SUBSTITUTE Function Result TRUE Sheet Result Description 1 TRUE Simple SUBSTITUTE formulas with local references and values Function Expected Correct FunctionString Comment Data ababababa a f 12abc12abc12abc 12abc12abc12abc TRUE =SUBSTITUTE("123123123","3","abc") Sales Data ababababa a f 12312abc123 12312abc123 TRUE =SUBSTITUTE("123123123","3","abc",2) Quarter 1, 2008 ababababa a f Cost Data Cost Data TRUE =SUBSTITUTE(I2, "Sales", "Cost") Quarter 1, 2011 ababababa a f Quarter 2, 2008 Quarter 2, 2008 TRUE =SUBSTITUTE(I3, "1", "2", 1) Quarter 1, 2012 Quarter 1, 2012 TRUE =SUBSTITUTE(I4, "1", "2", 3) fbfbfbfbf fbfbfbfbf TRUE {=SUBSTITUTE(K1:K4,L1:L4,M1:M4)} fbfbfbfbf fbfbfbfbf TRUE {=SUBSTITUTE(K1:K4,L1:L4,M1:M4)} #NAME? fbfbfbfbf fbfbfbfbf TRUE {=SUBSTITUTE(K1:K4,L1:L4,M1:M4)} fbfbfbfbf fbfbfbfbf TRUE {=SUBSTITUTE(K1:K4,L1:L4,M1:M4)} Err:502 Err:502 TRUE =SUBSTITUTE(I3, "1", "2", -1) Err:502 Err:502 TRUE =SUBSTITUTE(I3, "1", "2", 0)