Documentation/How Tos/Calc: REPLACE function

CALC FUNCTIONS

Text Functions

< Previous Section

Next Section >

FUNCTIONS

• Base
• Char
• Clean
• Code
• Concatenate
• Dollar
• Exact
• Find
• Fixed
• Left
• Len
• Lower
• Mid
• Proper
• Replace
• Rept
• Right
• Search
• Substitute
• T
• Text
• Trim
• Upper
• Value

< Previous Page

Next Page >

REPLACE

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

Syntax:

REPLACE(originaltext; startposition; length; newtext)

in originaltext, removes length characters beginning at character startposition, replaces them with newtext, and returns the result.

startposition and length must be 1 or more.

Example:

REPLACE("mouse"; 2; 3; "ic")

returns mice. Beginning at character position 2, 3 characters (ous) are removed and replaced by ic.

Issues:

• Excel and the forthcoming ODFF standard allow length to be zero.

---

See Also

• SUBSTITUTE
• FIND
• SEARCH

• Text functions

• Functions listed alphabetically
• Functions listed by category