Changing the Case of Text

[CW-NEN]

Is there a way of changing the case of text. I have been copying my data into word, using the change case function and then copying it back. I am afraid that something will go wrong and would like to keep my data in excel.

Quick addition: I am trying to get Title Case going. but going all upper of lower would not be so bad.

Thanks
Chris

 

[bryhamm]

Word calls it "title case." When the first letter of each word is capitalized.

Then the proper formula that we gave you should work