Start a conversation

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.


Choose files or drag and drop files
Was this article helpful?
  1. Carly Brown

  2. Posted