The Find function searches for the position of a text string in the text of a value.

The Left function returns the leftmost character or characters in a text string.

The Right function returns the rightmost character or characters in a text string.

The Mid function returns a specific number characters from text string, starting at the position you specify.

The Len function returns the number of characters in a text string.

The Lower function converts all the upper case letters in a text string to lower case.

The Upper function converts all the lower case letters in a text string to upper case.

The Exact function compares two text strings and returns true if they are exactly equal.

The Trim function removes all the leading and trailing white space from a text string.