String Function « Data Type « VBA / Excel / Access / Word

1.

Format() Formats strings, dates, and numbers as specified.

2.

InStrRev begins searching at the end of a string and returns the position where one string is found within another string:

3.

Instr function returns the position where one string begins within another string

4.

Left(string, length) returns the specified number of characters from the left end of a string

5.

Right(string, length) returns a specified number of characters from the right end of a string

6.

Mid(string, start[, length]) returns the specified number of characters from inside the given string

7.

UCase returns a string that is all uppercase

8.

InStr() Returns the location of the first character of a substring within another string.

9.

InStr(): A number representing the place value of a particular character within a string

10.

Using LTrim, RTrim, and Trim to Trim Spaces from a String

11.

Len() Returns the number of characters in a string.

12.

Len() return the number of characters in a string

13.

LCase() Converts the string to lowercase.

14.

UCase() Converts the string to uppercase.

15.

StrReverse() Reverses the order of the characters in a string.