fnGetExcelColumnName ( rep )

Converts numbers to related Excel column names (ie. 1 = A, 2 = B, 27 = AA, 28 = AB...)

Average rating: 4.5 (30 votes) Log in to vote

Drew Wesley - Show more from this author
Drewsol
https://www.drewsol.com

Sample input:

fnGetExcelColumnName ( 1 )
fnGetExcelColumnName ( 2 )
fnGetExcelColumnName ( 27 )
fnGetExcelColumnName ( 28 )

Sample output:

A
B
AA
AB

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let ( [
rep_div = Div ( rep + 26 - 1 ; 26 ) ;
rep_mod = Mod ( rep + 26 - 1 ; 26 ) ;
col_A = Choose ( rep_div - 2 ; "A" ; "B" ; "C" ; "D" ; "E" ; "F" ; "G" ; "H" ; "I" ; "J" ; "K" ; "L" ; "M" ; "N" ; "O" ; "P" ; "Q" ; "R" ; "S" ; "T" ; "U" ; "V" ; "W" ; "X" ; "Y" ; "Z" ) ;
col_B = Choose ( rep_mod ; "A" ; "B" ; "C" ; "D" ; "E" ; "F" ; "G" ; "H" ; "I" ; "J" ; "K" ; "L" ; "M" ; "N" ; "O" ; "P" ; "Q" ; "R" ; "S" ; "T" ; "U" ; "V" ; "W" ; "X" ; "Y" ; "Z" )
] ;
col_A & col_B
)

This function is used to convert column numbers (starting with '1') to related Excel column names.

Comments

		comment, VR Jun 28, 2014
Have a look at DecToAlpha ( ): http://www.briandunning.com/cf/399

		Drew Wesley, Drewsol Jun 28, 2014
Ah, I didn't see that one - thanks.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

fnGetExcelColumnName ( rep )

Comments

Support this website.

Support this website.