You would need a macro for that to be simple
Sub Upper_Case()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim Cell as Range
On Error Resume Next
For Each Cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
Cell.Formula = UCase(Cell.Formula)
Next
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
there is also a function called UPPER that will convert all letters to upper
case
to install macros see
http://www.mvps.org/dmcritchie/excel/install.htm
--
Regards,
Peo Sjoblom