How to Change the Case of Text in a Cell using Functions

Sometimes you need to change the case of all of the text in a cell in Excel.  If you are doing this for only one cell, that is no big deal and you might as well do it by hand.  However, this becomes a tedious and time-consuming process when you have to do it for many cells, and this is where functions come in handy.

In Excel, you can use the UPPER(), LOWER(), and PROPER() functions to change the case of text within a cell.  Each function has only one argument, a reference to a cell that contains the text you want to change.

So, to change the case of text in cell A1 to upper case, you would do this: =UPPER(A1).  To change the text to lower case: =LOWER(A1).  And, to change the case to proper case: =PROPER(A1).

The proper case simply means that the first letter of each word will be capitalized.

If you want to convert a long column of data using these functions, just input one function in the very next column and copy it down.  Then, select the new column, copy it (Ctrl + C) and paste special values (Alt + E + S + V Enter).  This will turn the functions into the text that they output.

Similar Topics - Q/A from Forums

Coming Soon