If you frequently change large strings of text from lowercase to uppercase characters, manually changing every lowercase character to uppercase can be tedious and slow.

Without giving much away, can you define a 1-1 mapping between lower case characters and upper case characters? Can you tell when a character is a lower case character?

Excel doesn't offer a one-click solution if you need text in sentence case (where only the first letter of the sentence is capitalized). But don’t worry! You can create a custom formula using the LEFT ...