Grabbing the right case
Excel has three functions that handle case. LOWER, UPPER and PROPER.
See image below for the results of using these functions. Cell A2 contains an entry.
Cell B2 has =LOWER(A2)
Cell C2 has =UPPER(A2)
Cell D2 has =PROPER(A2)
Note: The PROPER function capitalises the first letter of every word in the cell – see below.