Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making Sheet all Upper Case
Within my sheet, there are cells with lower case and cells with upper and I
would like to convert all to UPPER case, could someone please let me know how this is done? THanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making Sheet all Upper Case
Sub MakeUpperCase()
Dim cell As Range For Each cell in Activesheet.Usedrange.Cells cell.Value = UCase(cell.Value) Next cell End Sub -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Junderwood57" wrote in message ... Within my sheet, there are cells with lower case and cells with upper and I would like to convert all to UPPER case, could someone please let me know how this is done? THanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making Sheet all Upper Case
See here,
http://www.cpearson.com/excel/ChangingCase.aspx Junderwood57 wrote: Within my sheet, there are cells with lower case and cells with upper and I would like to convert all to UPPER case, could someone please let me know how this is done? THanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making Sheet all Upper Case
Maybe
Sub stantial() For Each c In ActiveSheet.UsedRange If Not c.HasFormula Then c.Value = UCase(c.Value) End If Next End Sub Mike "Junderwood57" wrote: Within my sheet, there are cells with lower case and cells with upper and I would like to convert all to UPPER case, could someone please let me know how this is done? THanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Renaming Sheet Tab to Upper Case Letters | Excel Discussion (Misc queries) | |||
Changing upper case characters to upper/lower | Excel Discussion (Misc queries) | |||
Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
HOW DO YOU CHANGE AN ENTIRE SPREAD SHEET FROM LOWER CASE TO UPPER | Excel Discussion (Misc queries) | |||
How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) |