Excel Formula: Capitalize only First Letter in a Cell

=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))


SOURCE: http://www.eggheadcafe.com/software/aspnet/33598771/-capitalize-only-first.aspx