It seems that it is easy for us to change the case for a group of words from lowercase to uppercase or from uppercase to lowercase in Microsoft Office Word 2007, but if you notice carefully there are no such handy options in Microsoft Office Excel 2007.

However, there is an alternative way for us to do so. For example, we would like to change all the text in Excel from lowercase to uppercase. You will need to use the formula =UPPERCASE().

Try this method. What we are going to do now is to copy them from Microsoft Excel and then paste to Microsoft Word.

In Microsoft Word, you will see a small Aa icon. Over there, you can choose to change your text to UPPERCASE.

Then, copy the UPPCASE text and paste them back to your Excel file.You will get the results.

You can also change all your text to Sentence case, lowercase, Capitalize Each Word, Half-width, Full-width or tOFFLE cASE. Just repeat the same steps.