simple clarification reg. changing of case

[gopalakrishnarao1]

I am having some data which are in capitals, Now I want to change this in this format. eg. GOPALA TO Gopala i.e. only first letter should be in upper case, rest should be in lower case. What I have to do?

 

[VoG]

Try

=PROPER(A1)

 

[p45cal]

look at the worksheet function Proper().