Apple iWork '09 - Manual (Page 318)

“UPPER” on page 324
“Listing of Text Functions” on page 306
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
REPLACE
The REPLACE function returns a string where a specified number of characters of a
given string have been replaced with a new string.
REPLACE(source-string, start-pos, replace-length, new-string)
 source-string: A string. source-string is a string value.
 start-pos: The position within the specified string at which the action should begin.
start-pos is a number value that must be greater than or equal to 1. If start-pos is
greater than the number of characters in source-string, new-string is added to the
end of source-string.
 replace-length: The number of characters to be replaced. replace-length is a number
value that must be greater than or equal to 1. If replace-length is greater than or equal
to the length of source-string, the returned string is equal to new-string.
 new-string: The text used as a replacement for the section of the given string that
is replaced. new-string is a string value. It does not have to be the same length as
the text replaced.
Example
=REPLACE(”received applicant’s forms”, 10, 9, “Frank”) returns “received Frank’s forms”.
Related Topics
For related functions and additional information, see:
“SUBSTITUTE” on page 322
“Listing of Text Functions” on page 306
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
318 Chapter 11 Text Functions