Brian Dunning's FileMaker Custom Functions

fnGetExcelColumnName ( rep )

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

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

Drew Wesley   Drew Wesley

Share on Facebook Share on Twitter

  Sample input:
fnGetExcelColumnName ( 1 )
fnGetExcelColumnName ( 2 )
fnGetExcelColumnName ( 27 )
fnGetExcelColumnName ( 28 )
  Sample output:

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

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



comment   comment, VR
Jun 28, 2014
Have a look at DecToAlpha ( ):
Drew Wesley   Drew Wesley, Los Angeles, CA
Jun 28, 2014
Ah, I didn't see that one - thanks.

Log in to post comments.


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

Under construction. Email me your wish list for improvements.