Keyboard shortcut to change case of text in cells in Excel 2010?
Paul's suggestion is good or you can write your own macros and assign shortcut keys
Sub makeUPPER()
ActiveCell = UCase(ActiveCell)
End Sub
Sub makeLOWER()
ActiveCell = LCase(ActiveCell)
End Sub
I used the following technique to convert a column of text to uppercase.
- Move the cursor to a blank column.
- In the empty cell on the same row as the first cell you want to convert, type
=upper(A3)
, if A3 is the first cell you want to convert. - The previously empty cell should now show the upper case equivalent of your first cell of text.
- Copy this cell down the column to the same height as all of your text.
- You should now have a column equivalent to your text, but all in uppercase.
- Highlight all of the cells of uppercase text, and select copy.
- Left-click on the first cell of your source text (which is not in uppercase), which will select the cell.
- Right-click.
- Select Paste Special
- In the list box, select "Values" radio button, and click OK.
- You will now have 2 columns of upper case text.
- Delete the column containing the
=upper()
formulas.
The same principle works for Proper, and other text manipulation functions.