Excel Formulas

Transforms Excel Letter Reference to a Corresponding Number and Vica Versa
  • EXCEL_LETTER_TO_NUMBER

    Transforms an Excel letter to number. A = 0, B = 1 etc

    EXCEL_LETTER_TO_NUMBER("AA")
    Try this example
    letter (string)
    Excel like column name
  • EXCEL_NUMBER_TO_LETTER

    Transforms an number to Excel letter. 0 = A, 1 = B etc

    EXCEL_NUMBER_TO_LETTER(100)
    Try this example
    number (number)
    Number to transform