MS-Excel / General Formatting

String Functions

Asc(string)The ANSI character code of the first letter in string.
AscB(string)The byte corresponding to the first letter in string.
AscW(string)The Unicode character code of the first letter in string.
Chr(charcode)The character, as a Variant, that corresponds to the ANSI code given by charcode.
Chr$(charcode)The character, as a String, that corresponds to the ANSI code given by charcode.
ChrB(charcode)The byte that corresponds to the ANSI code given by charcode.
ChrW(charcode)The Unicode character that corresponds to the ANSI code given by charcode.
Filter(sourcearray,match, etc.)Given an array of strings (sourcearray), returns a subset of strings (that is, another array) that match a criteria (match).
InStr(start, string1, string2)The character position of the first occurrence of string2 in string1, beginning at start.
InStrB(start, string1, string2)The byte position of the first occurrence of string2 in string1, starting at start.
InStrRev(stringcheck,stringmatch,start)The character position (working from the end of the string) of the first occurrence of stringmatch in stringcheck, beginning at start.
Join(sourcearray, delimiter)A string consisting of the concatenated values in a string array (sourcearray), separated by delimiter.
LCase(string)string converted to lowercase as a Variant.
LCase$(string)string converted to lowercase as a String.
Left(string, length)The leftmost length characters from string as a Variant.
Left$(string, length)The leftmost length characters from string as a String.
LeftB(string)The leftmost length bytes from string as a Variant.
LeftB$(string)The leftmost length bytes from string as a String.
Len(string)The number of characters in string.
LenB(string)The number of bytes in string.
LTrim(string)A string, as a Variant, without the leading spaces in string.
LTrim$(string)A string, as a String, without the leading spaces in string.
Mid(string, start, length)length characters, as a Variant, from string beginning at start.
Mid$(string, start, length)length characters, as a String, from string beginning at start.
MidB(string, start, length)length bytes, as a Variant, from string beginning at start.
MidB$(string, start, length)length bytes, as a String, from string beginning at start.
Replace(expression, find, replace)A string in which one or more instances of a specified substring (find) in an expression have been replaced by another substring (replace).
Right(string, length)The rightmost length characters from string as a Variant.
Right$(string, length)The rightmost length characters from string as a String.
RightB(string, length)The rightmost length bytes from string as a Variant.
RightB$(string, length)The rightmost length bytes from string as a String.
RTrim(string)A string, as a Variant, without the trailing spaces in string.
RTrim$(string)A string, as a String, without the trailing spaces in string.
Space(number)A string, as a Variant, with number spaces.
Space$(number)A string, as a String, with number spaces.
Split(expression, delimiter)An array consisting of substrings from a string expression in which each substring is separated by a delimiter.
Str(number)The string representation, as a Variant, of number.
Str$(number)The string representation, as a String, of number.
StrComp(string2, string2, compare)A value indicating the result of comparing string1 and string2.
StrReverse(expression)A string consisting of the characters from a string expression in reverse order.
String(number, character)character, as a Variant, repeated number times.
String$(number, character)character, as a String, repeated number times.
Trim(string)A string, as a Variant, without the leading and trailing spaces in string.
Trim$(string)A string, as a String, without the leading and trailing spaces in string.
UCase(string)string converted to uppercase as a Variant.
UCase$(string)string converted to uppercase as a String.
Val(string)The number contained in string.
[Previous] [Contents]