converting text from UPPER CASE to Proper Text

I have been pulling my hair out trying to figure out how to do this. I have a worksheet with several colunms of text that are all in upper case and I want to change all the cells in each column to proper text. How do I do this?