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 © 2024 TNG Consulting Inc.
Theme by Anders Noren — Up ↑