I'm trying to get 36 big excel files (all 1,000 plus entries) ready to
combine into one file to publish to the web. Unfortunately, about half have
all caps, and the rest have first-letter of each word capitalized.

Is there a quick way to format all of these at once? If not at once, is
there just a quick way to fix the all caps to first letter in each workbook
individually?

Thanks,
MB