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. Information here may no longer be accurate, and links 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).