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.