Where my articles grow up before they go public

Tag formula

Excel Formulas – Converting between double letters and numbers

Converting numbers (1, 2, 3…676) to two letters (AA, AB, AC…ZZ) in Excel Formula 1: =CHAR(65+TRUNC((A1-1)/26)) & CHAR(65+MOD(A1-1,26)) Converting two letters (AA, AB, AC…ZZ) to numbers (1, 2, 3…676) in Excel Formula 2: =(CODE(MID(B1,1,1))-65)*26 + CODE(MID(B1,2,1))-64 Example The figure bellow… Continue Reading →

Copyright © 2021 TNG Consulting Inc.

Theme by Anders NorenUp ↑