Spread 8.0 Documentation
REPLACE
Support Options
Formula Reference > Built-In Functions > REPLACE

Glossary Item Box

REPLACE


Name

Replace

Description

Replaces part of a text string with a different text string.

Syntax

REPLACE(Old_text, Start_char, Num_chars, New_text)

Remarks

Arguments are as follows:

Argument Description
Old_text Original text in which you want to replace characters.
Start_char Starting position in the original text to begin the replacement.
Num_chars Number of characters in the original text that you want to replace with characters from the new text.
New_text New text that will replace characters in the original text.

Use the REPLACE function to replace a specified number of characters in a specified location with other characters. Use the SUBSTITUTE function to replace specific text with other text.

See also FIND and SUBSTITUTE.

Data Type

Accepts string data for the Old_text argument, numeric data for the Start_char argument, numeric data for the Num_chars argument, and string data for the New_text argument. Returns string data. For more information, see Data Type for Each Cell Type.

Example

The following formula replaces three characters with one character, starting with the sixth character in the provided text:

fpSpread1.Formula = "REPLACE(""abcdefghijk"", 6, 3, ""%"")" equals "abcde%ijk"

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.