Class 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