Sometimes when I built the application for Excel, I’ll need to convert the Column number to Letter (say, 3 is C) or vice versa.
I’ve been searching around, and finally found the following methods which are quite useful and simple. They cater for column letter like “AB” too.
Function: Convert column number to letter ( 2 –> “B”)
Function: Convert column letter to number (“B” –> 2)