>I am attempting to do the following:
>
>Change the fields in an excel spreadsheet format to CAPS.
I don't see any special format in Excel to do that (Word has a "Caps" format). A special "caps" format would be convenient, since you can then later change it back as it was (to whatever mixed case you had originally typed in).
So, I think you would have to replace the cells one by one.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)