Class Replace

java.lang.Object
org.apache.poi.ss.formula.functions.Fixed4ArgFunction
org.apache.poi.ss.formula.functions.Replace
All Implemented Interfaces:
Function, Function4Arg

public final class Replace extends Fixed4ArgFunction
An implementation of the Excel REPLACE() function:

Replaces part of a text string based on the number of characters you specify, with another text string.
Syntax:
REPLACE(oldText, startNum, numChars, newText)

oldText The text string containing characters to replace
startNum The position of the first character to replace (1-based)
numChars The number of characters to replace
newText The new text value to replace the removed section

Author:
Manda Wilson < wilson at c bio dot msk cc dot org >