| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can you change an Excel spreadsheet from a combination od Upp. | Excel Discussion (Misc queries) | |||
| how do you change pathways (links) when consolidating spreadsheet. | Excel Discussion (Misc queries) | |||
| How do I change a spreadsheet from English to Spanish | New Users to Excel | |||
| How do I change a spreadsheet from all caps to "Proper" | Excel Discussion (Misc queries) | |||
| Automatic date change when spreadsheet changes | Excel Worksheet Functions | |||
Linear Mode
