I have been asked in the past how to make all text in an Excel worksheet either all upper or all lower case. I’m not sure why the person wanted this, but the point is that is what they wanted. I always try to take the stance that Excel can do whatever anyone asks me about. I just need to figure out the how of it.
So I have been asked about this often enough that I figure I need to do an article covering this topic.
Follow the steps below to find out how to accomplish this:
- Go to the text you want changed to upper case in your worksheet.
- In another cell, key in the formula =UPPER(A1)
- Click in another cell and you will quickly see the result of your formula.
Follow the steps below to change all text to lower case:
- Go to the desired text as above.
- In another cell, key in =LOWER(A2)
- View the result of your formula as above.
Ok, now that you have that down, how about we learn how to make the new text actual TEXT rather than a Function?
Follow the steps below to learn how:
The issue with the methods above is that the output of your formula whether it’s upper or lower case is not actually text. It is the output of the UPPER and LOWER functions in Excel. So now we need to have the original list of data in order to have the new list.
Follow the steps below to remove the original list of data and keep the new list with either upper or lower case text:
Select the output of the UPPER or LOWER function.
Click CTRL + C.
Click ALT + E +S +V.
Click Enter. To remove the copy outline you can just tap your ESC key after you click Enter.
Now, these cells after the last step contain only text. There is no more UPPER or LOWER function in these cells.
You can now do whatever you want with the contents of the new list!
As you can readily see, these functions are extremely helpful at manipulating your text and quickly and easily clean or update your data lists. I love something that saves time and keystrokes!