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

Hi,
With "abcd" in A1, enter "=UPPER(A1)" in B1 - no quotes. - to get "ABCD."
--
Ken Hudson


"Monique" wrote:

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

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

Monique wrote:
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