changing to proper text

[frances]

I have a spreadsheet that is text in the all caps
and I want to translate it to Proper text. how do I do
that to the entire spread sheet or one column at a time:

 

[J.E. McGimpsey]

Take a look here:

http://www.mvps.org/dmcritchie/excel/proper.htm