Convert text to upper case

Try

Formula:

=UPPER(A1)

If you want to convert selected cells you must use VBA:

Right click on sheet name -> View code

and paste:

Public Sub ConvertUpper()
Dim rngArea As Range
For Each rngArea In Selection 
    With rngArea
        .Value = Evaluate("IF(ISTEXT(" & .Address & "),UPPER(" & .Address & "),REPT(" & .Address & ",1))")
    End With
Next rngArea
End Sub

Then select any range and run this macro.

VBA solution here, converts text once enter is pressed

http://excel.tips.net/T002568_Forcin...Uppercase.html