How to extract only capital letters to different cells
Used Functions
Category: Logical
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
Syntax
IFERROR(value, value_if_error)
Practice IFERROR Formula at Sheetzoom
IFERROR formula at Microsoft helpCategory: Lookup and reference
Uses an index to choose a value from a reference or array
Syntax
INDEX(array, row_num, [column_num])
Category: Text
Returns a specific number of characters from a text string starting at the position you specify
Syntax
MID(text, start_num, num_chars)
Category: Lookup and reference
Returns the row number of a reference
Syntax
ROW([reference])
Category: Lookup and reference
Returns a reference indicated by a text value
Syntax
INDIRECT(ref_text, [a1])
Category: Text
Returns the number of characters in a text string
Syntax
LEN(text)
Category: Statistical
Returns the k-th smallest value in a data set
Syntax
SMALL(array, k)
Category: Logical
Specifies a logical test to perform
Syntax
IF(Something is True, then do something, otherwise do something else)
Category: Information
Returns TRUE if the value is a number
Syntax
ISNUMBER(value)
Category: Lookup and reference
Looks up values in a reference or array
Syntax
MATCH(lookup_value, lookup_array, [match_type])
Category: Text
Returns a numeric code for the first character in a text string
Syntax
CODE(text)
Category: Lookup and reference
Returns the column number of a reference
Syntax
COLUMN([reference])
0
This formula checks for the code of the character to identify it and then extracts only those letters that are capital.