Thursday, November 12, 2009

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

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...