How do I change everything in my spreadsheet to all UPPERCASE?
 

I'm just trying to make everything in my spreadsheet the same case. Is there
an easy way to do this, like there is in Word?
--
bootsy

Go into VBE and enter the following all in one line

for each sht in this workbook.sheets:for each cl in
sht.usedrange.cells:cl.value=ucase(cl.value):next: next

replace ucase with lcase if you desire lowercase

http://HelpExcel.com

"Bootsy" wrote:

I'm just trying to make everything in my spreadsheet the same case. Is there
an easy way to do this, like there is in Word?
--
bootsy

Remove the space I accidentally embedded between the word this and workbook...

It should read thisworkbook

"Bootsy" wrote:

I'm just trying to make everything in my spreadsheet the same case. Is there
an easy way to do this, like there is in Word?
--
bootsy

No, but take a look he

http://www.mvps.org/dmcritchie/excel/proper.htm#upper

In article ,
Bootsy wrote:

I'm just trying to make everything in my spreadsheet the same case. Is there
an easy way to do this, like there is in Word?