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

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

Guest

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?
 
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
 
Remove the space I accidentally embedded between the word this and workbook...

It should read thisworkbook
 
You must log in or register to reply here.

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

Split cell based on uppercase letter 2
How to change mixed case to upper case in Excel for all cells 8
uppercase to lowercase 4
Search for lowercase followed by uppercase and insert paragraph 3
Keep spreadsheet on pc & laptop in sinc -how? 3
Converting "uppercase" string data to "lower case" in CSV file 2
automatically changing text case 4
How do I do a global change from uppercase to lowercase? 2

Back
Top