Category: String

0

VBA-Excel: String Functions – String()

Description:  The String() function returns a string consisting a repeating characters of specified length. Format: String(number,character) Arguments: number Mandatory Type: Numeric No of times the character to be repeated, means length of the returned...

0

VBA-Excel: String Functions – strComp()

Description: The strComp() function compares the two strings and returns the comparison result in numeric form. Format: StrComp(string1, string2[, compare]) Arguments: String1 Mandatory Type: String First string which gets compared with another one

1

VBA-Excel: String Functions – Space()

Description: The Space() function returns a string consisting a specified number of spaces. Format: Space (intNumberOfSpaces) Arguments: intNumberOfSpaces Mandatory Type: Numeric Number of spaces you want in the string.

11

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

0

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

0

VBA-Excel: String Functions – Len()

Description: The Len function returns the number of characters in a string including spaces. Format: Len (strMainString) Arguments: strMainString Mandatory Type: String String who’s both number of characters to be returned.

2

VBA-Excel: String Functions – Trim()

Description: The Trim function removes spaces on the left and right side of a string. Format: Trim (strMainString) Arguments: strMainString Mandatory Type: String String whose both side spaces needs to be trimmed.

0

VBA-Excel : Strings Functions – Right

Description: Returns a string containing number of characters specified by the user, starting from right side of the input string. Format: Right(strMainString,intLength) Arguments: strMainString Mandatory Type: String String whose characters to be returned.

0

VBA-Excel : Strings Functions – Left

Description: Returns a string containing number of characters specified by the user, starting from left side of the input string. Format: Left(strMainString,intLength,) Arguments: strMainString Mandatory Type: String String whose characters to be returned.

0

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

Show Buttons
Hide Buttons
%d bloggers like this: