In MS Excel, does anyone know how to change capitalization of the data?

Question

The data is all caps now and I want to change from: EXAMPLE to Example.

Is there a way to do it?
Is there a way to do it for both words if there are 2 in each field?

Thanks for your help!

Where would I enter "=Proper()" to change the entire spreadsheet?

Answer 1

There are 3 case functions in Excel

lower() - converts to ALL lower case
upper() - converts to ALL upper case
proper() - Capitalizes the first letter of each word

Therefore if A1 contains "tHe CaT is blACK"

lower(A1) returns "the cat is black"
upper(A1) returns "THE CAT IS BLACK"
proper() returns "The Cat Is Black"

Answer 2

You can use the =Proper() function.

Yahoo answers does not allow text formatting to post a chart example.

If the data is in say cell A1 than B1 would be =Proper(A1)