Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

If cell A1 contains the letter A (uppercase) The following formula returns the letter a (lowercase)

Input the formula: =CHAR(CODE(A1)+32) Each lowercase letter lies exactly 32 character positions higher than its corresponding uppercase letter.