Microsoft KB Archive/812315

= MACXL: How to Change the Case of Text =

Article ID: 812315

Article Last Modified on 2/1/2007

-

APPLIES TO


 * Microsoft Excel X for Mac
 * Microsoft Excel 2001 for Mac

-





For a Microsoft Excel for Windows version of this article, see 263580.



SUMMARY
This article describes how to use worksheet functions to change the case of text.



MORE INFORMATION
Excel has the following three worksheet functions that you can use to change text case:
 * LOWER: Converts all uppercase letters in a text string to lowercase.
 * UPPER: Converts all lowercase letters in a text string to uppercase.
 * PROPER: Capitalizes the first letter in a text string and any other letters that follow any character other than a letter. Converts all other letters to lowercase letters.

By using these functions, you can change the case of existing text in a worksheet. For example, type the following values in the designated cells in a worksheet:

To make the text in these cells lowercase, follow these steps:

 In cell B1 type the following:

=LOWER(A1)

 In column B, select all the cells to the right of the cells that contain data in column A. On the Edit menu, point to Fill, and then click Down.

The new column now contains the lowercase version of the text in column A. While the range of cells are still selected in column B, click Copy on the Edit menu. Select cell A1, then on the Edit menu, click Paste Special. Click Values, and then click OK'''.

The converted values are pasted on top of the original values in column A.'''</li></ol>

The text that was in column A is now in lowercase:

<div class="references_section">