Tuesday, October 27, 2009

Function to change case to sentence case in Excel 2007

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