« Selecting an entire sheet | Main | Basic Functions: LARGE, SMALL »
October 22, 2004
Basic functions : REPLACE, SUBSTITUTE
When do we use REPLACE and when do we use SUBSTITUTE? We will answer this question with some basic examples of both functions.With REPLACE, we specify the position and lenght of the substring to be replaced, what that substring is, we don't know.
With SUBSTITUTE, we know what we are replacing, just not sure exactly where it is in the target string.
Posted by Dave at October 22, 2004 04:25 AM
Comments
Hello,
Thanks for the tip !
Except that it's "Substitue" instead of "Substitute"...
Cheers!
G.
Posted by: Guillaume at February 21, 2005 02:50 PM