Chat with us, powered by LiveChat

You're currently on:

Change Text Case

Antoinette Collins posted this on Sep 30, 2016

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.

Change Text Case

Categories: Documents and Lists