Cube Long Arrow Right External Link angle-right Search Times Spinner angle-left

Change Text Case

Microsoft 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 in text 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. Look at the example below.  The names of all the current Click2Mail employees are entered into column one in the excel spreadsheet pasted below.