REPLACE function

CALC FUNCTIONS

Text Functions

< Previous Section

Next Section >

FUNCTIONS

• ARABIC
• ASC
• BASE
• BAHTTEXT
• CHAR
• CLEAN
• CODE
• CONCATENATE
• DECIMAL
• DOLLAR
• EXACT
• FIND
• FIXED
• JIS
• LEFT
• LEN
• LOWER
• MID
• PROPER
• REPLACE
• REPT
• RIGHT
• ROMAN
• SEARCH
• SUBSTITUTE
• T
• TEXT
• TRIM
• UNICHAR
• UNICODE
• 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 ODFF standard allow length to be zero.

---

See Also

• SUBSTITUTE
• FIND
• SEARCH

• Text functions

• Functions listed alphabetically
• Functions listed by category