Formulas and Functions

Table Of Contents

“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 specied 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 specied 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”.