In Microsoft Excel, how do I convert lowercase letters to uppercase or vice versa?

If you have a lot of cells or rows that you want to convert, Excel provides a feature that enables you to easily convert those cells or rows to uppercase or lowercase. Consider the following spreadsheet:

To convert the lowercase text to uppercase, use the =upper(source) command, where source is the cell's location (e.g., A21 if the source is in column A, row 21).

For example, in cell B21, type =upper(A21), as shown below:

This will result in the following:

To make each of the items in column A appear in uppercase letters in column B, highlight cell B21. From the Edit menu or Home tab, select Copy. (You are copying the formula in this instance.) Now highlight cells B22 through B25. From the Edit menu or Home tab, select Paste. The results should look like the following:

To convert from uppercase to lowercase, follow the same procedure, substituting =lower(source) for =upper(source) .

Comments/Questions/Corrections