I was asked the other day “How do I change the text in an Excel spreadsheet so they’re all uppercase or all lowercase?” I guessed that text had already been entered so I gave this response.

Personally I don’t like upper case text it looks the writer is shouting. To convert cells that have upper case text to lower case use the =LOWER() function.

If you need to shout and use upper case then =UPPER() will convert text to upper case

If you are looking for titles try =PROPER(). This will convert to text that has the first letter of each word capitalised.

If I have the following text in a cell: Here is my Text

• UPPER() returns HERE IS MY TEXT
• LOWER() returns here is my text
• PROPER() returns Here Is My Text

I don’t believe that there is an option in Excel to enter data and have it formatted as Upper or Lower case.