How do I change lowercase data to capped data?
 

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

How do I change lowercase data to capped data?
 

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

How do I change lowercase data to capped data?
 

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