You can insert a column next to the one that contains the text that is in all
caps. In a blank cell in your new column, insert the function '=Proper(A1)'
(dont use the quotation marks)... You can drag that function down the entire
column so that it converts the entire column without you having to retype the
formula wach time. After you are done, copy the new column with the corrected
text, then 'paste special', 'values' in the same location. This will give you
the Proper Cased data in text, not in the the form of the formula you imput.
After that is done you can get rid of the original column of all caps data.
Sorry if this is too confusing, I was never great at giving directions, I
just thought I would try to help.

" wrote:

I download information from outside sources into a .CSV file, which I
then save as an EXCEL file. The information contains large quantities
of text - which in its original format is all caps. Once I download
it, or as I am downloading and saving - is there anyway I can format
the cells to first letter cap only?