& (ampersand)

= "Yellow "&"river"

Concatenates specified strings.

CONCATENATE

=CONCATENATE("Developer"; " Express")

Joins several text strings in one text string. An alternative to "&".

DOLLAR

=DOLLAR(957.344; 2)

defining the value and the number of digits to the right of the decimal point in the output string.Converts the number to text using currency format $#,##0.00_);($#,##0.00), with the decimals rounded to the specified number of placesThe first argument of type double is required.  The second argument of type integer is optional (the default value is 2).  The third argument of type Boolean is optional.

FIXED

=FIXED(1234.567, 1)

Rounds the first argument to the number of decimals determined by the second argument and returns it as a string.  The third parameter specifies whether to omit commas in the output string.The first argument of type string is required.  The second argument of type integer is optional.

LEFT

=LEFT(A1)=LEFT(A1, 3)

Returns the first character or characters in a text string.  The second parameter defines the number of characters to extract.  The default value is 1.

LEN

=LEN("ABC")        

Returns the length of a given string.

LOWER

=LOWER(A1)        

Converts a string to lowercase.

MID

=MID("ABC",3,1)

The first argument is of type string, the second and the third arguments are of type integer.        . Returns the substring of a given text string.  The position of the substring is defined by the second parameter.  The third parameter specifies the number of characters to extract

RIGHT

=RIGHT(B2, 3)

The first argument of type string is required.  The second argument of type integer is optional.                Returns the last character or characters in a text string.  The second parameter defines the number of characters to extract.  The default value is 1.

TRIM

=TRIM("   Express Spread Sheet   ")        

Removes all spaces from text except for single spaces between words.

UPPER

=UPPER(A1&A2)

Converts a string to uppercase