Apply title case ("proper case") to an entire spreadsheet?

The PROPER function in Microsoft Excel:

Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.

I have a spreadsheet that has hundreds of rows, each row with dozens of columns, and I want to apply the PROPER function (or a similar "capitalize the first letter of each word, lowercase the rest" transformation) to every cell, in-place. When I'm done, the old (all uppercase) values are no longer needed--I only need the transformed versions.

Is there a straightforward way to do this?

2 Answers

Not really an excel solution, but fast.

[ Select All(in excel) , copy > paste in Notepad++

| Select all(in notepad++) > Edit >Convert Case to > Proper Case

| Select All(in notepad++) , copy > paste in excel ]

Try this formula:

=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))