Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
"CAPS" an Entire Document
- Thread starter Spec01
- Start date
fredericofonseca
IS-IT--Management
either use a small VBA macro to do that for you
or
create another spreadsheet type "=upper(_here_you enter the first cell (A1) of your other spreadsheet) in cell A1
then copy A1 to all other cells of the spreadsheet.
You should now have a upper case only spreadsheet. to replace the original you need to copy the full content and do a paste special -> values. (you will loose all your formulas so it may not be the option you should pursue.
It will depend on what you are trying to do. VBA is very easy, and you will find code on these forums that will help you loop through the cells to do that.
Regards
Frederico Fonseca
SysSoft Integrated Ltd
or
create another spreadsheet type "=upper(_here_you enter the first cell (A1) of your other spreadsheet) in cell A1
then copy A1 to all other cells of the spreadsheet.
You should now have a upper case only spreadsheet. to replace the original you need to copy the full content and do a paste special -> values. (you will loose all your formulas so it may not be the option you should pursue.
It will depend on what you are trying to do. VBA is very easy, and you will find code on these forums that will help you loop through the cells to do that.
Regards
Frederico Fonseca
SysSoft Integrated Ltd
If you are not up to VBA yet then have a look at It's a very useful and free utility with hundreds of functions. It includes the function to convert your worksheet in capitals with just one mouseclick!
Have fun,
Ries
Have fun,
Ries
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
