Returns the character specified by a number

CHAR(number)

Lookup values by column in a horizontal table or range

=HLOOKUP (lookup_value, table_array, row_index_num, [range_lookup])

Return the k-th smallest value in a range

SMALL(array, k)

Return the value or reference of specified cell(s)

Array form: =INDEX(array, row_num, [column_num])

Reference form: =INDEX(reference, row_num, [column_num], [area_num])

Replace one or many instances of specific text based on its content (not on its position).

SUBSTITUTE(text, old_text, new_text, [instance_num])

Find specific text and its related starting position within a text string.

FIND(find_text, within_text, [start_num])

FINDB(find_text, within_text, [start_num])

Replace part of a text string based on its position with new text.

REPLACE(old_text, start_num, num_chars, new_text)

Count values in a range that meet multiple specific criteria.

COUNTIFS(range1, criteria1, [range2], [criteria2], ...)

Count the number of characters in a string

LEN(text)

Lookup values by row in a vertical table or range

=VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

Return the logical value TRUE if the cell contains a reference.

=ISREF(value)

Remove irregular spacing from either end of or within a text string.

TRIM(text)

Returns the median or middle number in a data set.

=MEDIAN(number1, [number2], ...)

Return the logical value TRUE if the cell contains either a TRUE or FALSE statement.

=ISLOGICAL(value)

Return a random integer number between 2 values

=RANDBETWEEN(bottom,top)