Excel text functions
UPPER(cell_reference) LOWER(cell_reference) PROPER(cell_reference) TRIM(text) EXACT(cell_reference1, cell_reference2) The result is True for an exact match or False for no match. FIND(find, within, start_number) where the first two arguments are required. The start_number argument is optional and allows you to specify with which character position to start the search. REPLACE(current_text, start_number, number_characters, new_text) where each argument is required. Let’s look at … Read more