How to change cases in a paragraph of text?

3 convenient functions in Excel can change the capitalization of all texts:

1. UPPER – Converts all text to upper case. For example =upper(“McDonalds”) will turn out to be MCDONALDS
2. LOWER – Converts all text to lower case. For example =lower(“McDonalds”) will turn out to be mcdonalds
3. PROPER = Converts first letter of each word to upper case, the rest to lower case. For example =proper(“McDonalds”) will turn out to be Mcdonalds