How do I change lowercase data to capped data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

uppercase to lowercase 4
How do I change uppercase to lowercase without re-typing (Excel) 1
how do i change the words from lower case to uppercase/capitals 3
Changing uppercase to lowercase 4
lowercase to caps 1
How to i capitalize all words in an existing worksheet? 3
Changing from lower case to upper case 11
How do I do a global change from uppercase to lowercase? 2

Back
Top