Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

Sentence case

Input the formula: =UPPER(LEFT(A1,1)) & RIGHT(A1,LEN(A1)-1)