Get only the first character in uppercase

[Anonymous]

I have a list of name in upper cases and i would like to put them on a table in a sheet but with only the first letter in upper case. 

I tried with Lower but couldn't find a way to put only the first char in upper case

[ggijben · Accepted solution]

Hi, 

Please try  =Capitalize(<Fieldname>) 

[Anil_Babu_Samineni]

You can even try this?
upper(left(Fieldname,1))&mid(Fieldname,2,len(Fieldname)-1)