If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change Case
I have the same question. Is there an easy way to change
data in an entire spreadsheet from lower to uppercase? |
#2
|
|||
|
|||
Change Case
Take a look at David McRitchie's Upper() macro:
http://www.mvps.org/dmcritchie/excel/proper.htm#upper But PLEASE reconsider! ALL CAPS IS A PAIN IN THE NECK TO READ! In article , "Gary Ballance" wrote: I have the same question. Is there an easy way to change data in an entire spreadsheet from lower to uppercase? |
#3
|
|||
|
|||
Change Case
try
Sub ucaseall() For Each c In ActiveSheet.UsedRange c.Value = UCase(c) Next End Sub "Gary Ballance" wrote in message ... I have the same question. Is there an easy way to change data in an entire spreadsheet from lower to uppercase? |
Thread Tools | |
Display Modes | |
|
|