Check out

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

In article ,
"Karen" wrote:

I have an existing worksheet with over 50,000 rows and 15 columns. Several
columns have information in all uppercase. I need to convert these words
into proper case. The information given in Excel Help only gives information
about changing individual cells. Does anyone have any suggestions?