IFERROR(...)

Category: Logical

Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula

IFERROR(value, value_if_error)

Category: Lookup and reference

Uses an index to choose a value from a reference or array

INDEX(array, row_num, [column_num])

Category: Text

Returns a specific number of characters from a text string starting at the position you specify

MID(text, start_num, num_chars)

Category: Lookup and reference

Returns the row number of a reference

ROW([reference])

Category: Lookup and reference

Returns a reference indicated by a text value

INDIRECT(ref_text, [a1])

Category: Text

Returns the number of characters in a text string

LEN(text)

Category: Statistical

Returns the k-th smallest value in a data set

SMALL(array, k)

Category: Logical

Specifies a logical test to perform

IF(Something is True, then do something, otherwise do something else)

Category: Information

Returns TRUE if the value is a number

ISNUMBER(value)

Category: Lookup and reference

Looks up values in a reference or array

MATCH(lookup_value, lookup_array, [match_type])

Category: Text

Returns a numeric code for the first character in a text string

CODE(text)

Category: Lookup and reference

Returns the column number of a reference

COLUMN([reference])

0

This formula checks for the code of the character to identify it and then extracts only those letters that are capital.