Text Functions MSOfficeExcel 2007 Tutorial

  1. Home
  2. MSOfficeExcel 2007 Tutorial
  3. Text Functions
  4. 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.