VBA Functions: Text

Find the list of all the main VBA functions on the VBA Functions page.

Text

Asc	Returns the integer corresponding to a character.
Chr	Returns the character corresponding to the integer argument.
Format	Returns a string according to a date or number in the specified format.
InStr	Returns an integer corresponding to the position of a value in a string.
InStrRev	Returns an integer corresponding to the position of a value in a string starting from the right.
LCase	Converts a string to lowercase.
Left	Returns the specified number of characters from a string from the left.
Len	Returns the number of characters in a string.
Mid	Returns the specified number of characters from a string starting from the defined character number.
Replace	Returns a string after replacing the substring(s) matching the searched value.
Right	Returns the specified number of characters from a string from the right.
StrReverse	Returns a string after reversing the order of the characters.
Trim	Returns a string after removing the spaces at the left and right of the string.
UCase	Converts a string to uppercase.