Sentence case: Just the first word needs to start with an uppercase letter and the rest of the string is all lowercase : UPPER « Text functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =UPPER(LEFT(A1,1)) & RIGHT(A1,LEN(A1)-1)
Input the formula: =UPPER(LEFT(A1,1)) & RIGHT(A1,LEN(A1)-1)
22.24.UPPER
22.24.1.UPPER(text) converts text to uppercaseUPPER(text) converts text to uppercase
22.24.2.Sentence case: Just the first word needs to start with an uppercase letter and the rest of the string is all lowercaseSentence case: Just the first word needs to start with an uppercase letter and the rest of the string is all lowercase