Apple iWork Numbers Function Reference

REPLACE

Description

The REPLACE function replaces part of a string with characters from a second string. The text to be replaced is specified by its length and position in the text.

Syntax

REPLACE(current-text, start, length, new-text)

• current-text: A text expression.
• start: A number indicating the first character to replace.
• length: The number of characters to replace.
• new-text: The replacement text.

Note: The new text doesn’t need to be the same length as the removed text.

Examples