VBA-Excel: String Functions – Replace()

Description: 

The Replace() function returns a string after replacing a part of string with another substring. The no of replacements depends on the parameters provided.

Format:

Replace(strMainString, find, replace[, start[, count[, compare]]])

Arguments:
  • strMainString
    • Mandatory
    • Type: String
    • The string in which replacements to be made.
  • Read more

VBA-Excel: String Functions – Mid()

Description: 

The Mid() function returns substring from a string and size of the substring is decided based on the parameters provided.

Format:

Mid (strMainString,start[,length])

Arguments:
  • strMainString
    • Mandatory
    • Type: String
    • Substring will be returned from this main string.

    Read more

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 more

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:

  • start
    • Optional
    • Type:     Numeric
    • Starting position from where search has to be started.
    • Required if compare argument is specified.

    Read more