shortcut how to change small letter to capital letter in excel 2007

Hi,you can make it with the Module item on the insert menu in VBA to realize it:

Sub ChangeCase()
    Dim Rng As Range
    On Error Resume Next
    Err.Clear
    Application.EnableEvents = False
    For Each Rng In Selection.SpecialCells(xlCellTypeConstants, _
             xlTextValues).Cells
        If Err.Number = 0 Then
 

Example:
cell A1: MINERVA
cell B1, type this =LOWER(A1)
will result minerva in B1

cell C1, type this =UPPER(B1)
will result MINERVA in C1

cell D1, type this =PROPER(C1)
will result Minerva in cell D1

Hope this helps and Good luck.

Example:
cell A1: MINERVA
cell B1, type this =LOWER(A1)
will result minerva in B1

cell C1, type this =UPPER(B1)
will result MINERVA in C1

cell D1, type this =PROPER(C1)
will result Minerva in cell D1

Hope this helps and Good luck.

Example:
cell A1: MINERVA
cell B1, type this =LOWER(A1)
will result minerva in B1

cell C1, type this =UPPER(B1)
will result MINERVA in C1

cell D1, type this =PROPER(C1)
will result Minerva in cell D1

Hope this helps and Good luck.