Column number code of EXCEL - (Nov/10/2012 )
Excel uses a triple letter code to specify columns;
does anyone know a system or formula to transfer such code to a real number;
f.i. "ATE" means which number?
thanks for assistance in advance
I guess you need a simple script to convert the alphabetic code to numeric.
ATE = (26 x 26 +1) + (26 x 20) + 5 = 1202 (I hope my calculation is right)
IV = 265 = 9 x 26 + 22 = 256
You can do it directly in Excel if you are using Excel 2007 or above. See this video
thanks pcrman, very helpful;
but I think there is a slight mistake in your formula:
ATE = (26 x 26 +1) + (26 x 20) + 5 = 1202
but I think it must be:
ATE = (26 x 26 x 1) + (26 x 20) + 5 = 1201