How do I change lowercase data to capped data?

M

Monique

I have a bunch of data that I typed in lowercases in lots of cells. What can
I do to change the data to uppercase letters all at the same time? I don't
want to have to retype the data.

Thank you
 
R

Rowan Drummond

If you want to do it all in place without using the UPPER formula then
select the cells you want to change and run this macro:

Sub UpperCase()
Dim r As Range
For Each r In Selection
If Not r.HasFormula Then r.Value = UCase(r.Value)
Next r
End Sub

Hope this helps
Rowan
 
Top