Microsoft Excel 2007 - Converting Text to Its Proper Case

Sometimes a client sends me an Excel file where all the data is in CAPS.   Did you know that there is an easy way to convert that text to the "Proper" format?

In any column, use this formula:

=PROPER(A1)

A1 would be the cell that you want to reformat.