apple script for UpperCase

[wildmomo]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Group - I am very new to Mac and loving it. However, I found out the hard way today that macros are not around anymore. Does or can anyone provide me with a down and dirty apple script that will do case conversion in a spreadsheet. I have a huge number of books and sheets that I need to make conversions on, and this would greatly be apprecaited.

Regards,

Wayne

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Group - I am very new to Mac and loving it. However, I found out the hard way
today that macros are not around anymore. Does or can anyone provide me with a
down and dirty apple script that will do case conversion in a spreadsheet. I
have a huge number of books and sheets that I need to make conversions on, and
this would greatly be apprecaited.

Regards,

Wayne

What kind of case conversion do you need to do? You may be able to do it in
bulk with a simple formula using Upper, lower, or proper and then pasting
the results back.

 

[wildmomo]

I was using this method of conversion, but I have so much data that I really need a macro/script to run on the workbooks as they come in from people in the field.

So we have dozens of fields that get filled-in in a workbook and the field engineers are not very consistent in using caps where they need to and such.

Any help is greatly appreciated.

Wayne