Use "PROPER" formula to convert the first alphabet into Capital letters
if A1 = "KRISHNA"
Then
=PROPER (A1) = Krishna
if A1 = "krishna"
Then
=PROPER (A1) = Krishna
if A1 = "Name"
Then excel formula of Upper works as under
=UPPER (A1) = NAME
&
=LOWER (A1) = name