There may be times when you need to change the case of your Excel data. Perhaps you imported a file from another sources and it came in as either all upper case or all lower case. Or perhaps you were typing along without realizing that you had inadvertently pressed the Caps Lock key.
The only way to change of multiple cells in Excel is by use of an easy little formula.
To Change the Case in Excel:
- Click in the column (or insert a new column) next to the column that contains the data you wish to change.
- Click in the first cell in the blank column. You will now create a formula to reference the column containing the data.
- Type your formula using one of the following functions (this assumes the cell containing the data is cell B1):
= Upper(B1)
= Lower(B1)
= Proper(B1) - Drag down (or copy) the formula in the first cell to the remaining cells in the data series.
- Select all of the cells that contain the new formula and click the Copy button on the Home Ribbon.
- Click the arrow on the Paste button on the Home Ribbon and choose Paste Values from the menu.
- You can now delete the original column from your worksheet.
Similar Posts:
- Changing Case in Excel using the Proper function
- Absolute Cell References in Excel
- Converting Formula Results to Values in Excel
- Using Relative References in Excel
- Creating a Refreshable Web Query in Excel
- Using 3-D Formulas and References in Excel
- Easily Move or Copy a Worksheet in Excel
