=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))
SOURCE: http://www.eggheadcafe.com/software/aspnet/33598771/-capitalize-only-first.aspx
Thursday 12 November 2009
Excel Formula: Capitalize only First Letter in a Cell
Posted on 19:08 by Unknown
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment