Here’s my quick tutorial on how to change uppercase to title case in Excel (and Sublime Text). A typical reason is to convert UPPERCASE English translations into corrected “I” for lettering or typesetting. We do this to prevent crossbar I’s from showing up on most fonts in the middle of words. (In most cases, companies are usually okay with crossbar I at the beginning of sentences)
Note: This only works with uppercase fonts! If you’re using lowercase fonts, you will have to google another method.