VBA-Excel : Strings Functions – InstrRev

Description:

InstrRev: This function returns the position of last occurrence of a string into another string, as a variant, based upon the arguments are provided, OR you can say that it returns the position of the first occurrence of a string into another string from the end of the string.

Format:

InStrRev(mainString, searchedString[,start, ] [, compare])

Arguments:

  • mainString
      • Mandatory
      • Type: String
      • String being searched.

    Read moreVBA-Excel : Strings Functions – InstrRev

    VBA-Excel : Strings Functions – Instr

    Description:

    Instr: This function returns the position of first occurrence of a string into another string, as a variant, based upon the arguments are provided.

    Format:

    InStr([start, ]mainString, searchedString[, compare])

    Arguments: