thomaslarsen/gist:5ba7ef6f3cfc72313231

Created June 17, 2015 10:44

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/thomaslarsen/5ba7ef6f3cfc72313231.js"></script>
Save thomaslarsen/5ba7ef6f3cfc72313231 to your computer and use it in GitHub Desktop.

Download ZIP

Excel formula to generate the column name in a cell

Raw

gistfile1.txt

=IF(COLUMN()>26,CHAR(INT((COLUMN()-1)/26)+64),"")&CHAR(MOD(COLUMN()-1,26)+65)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment