HI

[nase]

Hi there,

How can I convert small letters to cap in excel.
Ex: i did not do my homework today
to:
I DID NOT DO MY HOMEWORK TODAY.

I need the entire worksheet in cap letters!

is it possible?

Thank you

 

[PeteSweet]

=upper(i should try using a better title rather than just "hi")

 

[nase]

Thanks! I realized that after I posted, was in a hurry.

 

[nase]

=upper

How can I change that on my worksheet.

 

[CWatts]

If you want to actually change the data already there, you can use VBA

Insert this macro, highligh all the data you want to convert and then run the macro.

Be careful not to select the whole worksheet as it will take a long time to run, just highlight the range that has the data you want to uppercase.

Sub LetterUpper()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
 
For Each c In Selection
    c.Value = UCase(c.Value)
Next
 
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub