
Chapter 6 Working with Text, Dates, and Times132
function also replaces substrings; however, it does so by going to the indicated position.
As an example, consider the following formula:
=REPLACE(“Half this game is ninety percent mental”,19,4,
“seven”)
This will return the string “Half this game is seventy percent mental”. The
second argument, 19 in the above formula, specifies the beginning position for replace-
ment. The third argument, 4 in the above formula, specifies how many characters
should be replaced. The last argument in the REPLACE function, “seven” in the above
example, specifies the replacement substring.
Try It
Copy a ...