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.
    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