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

This content has been archived, and is no longer maintained by Indiana University. Resources linked from this page may no longer be available or reliable.

In Excel, you to easily convert a group of cells or rows to uppercase or lowercase. Consider the following spreadsheet:

  A B
21 dog  
22 cat  
23 mouse  
24 duck  
25 raccoon  

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:

  A B
21 dog =upper(A21)
22 cat  
23 mouse  
24 duck  
25 raccoon  

This will result in the following:

  A B
21 dog DOG
22 cat  
23 mouse  
24 duck  
25 raccoon  

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 to copy the formula. Now highlight cells B22 through B25. From the Edit menu or Home tab, select Paste. The results should look like the following:

  A B
21 dog DOG
22 cat CAT
23 mouse MOUSE
24 duck DUCK
25 raccoon RACCOON

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

This is document aink in the Knowledge Base.
Last modified on 2018-01-18 12:51:05.

Contact us

For help or to comment, email the UITS Support Center.