numberToLetter.cfm

<!--- 
		
	Function Name 	: numberToLetter()
	Author 			: Ryan Spencer
	Created 		: 22/05/2012
	General Notes 	: convert a number into a letter similar to how excell columns work.
	
	Function in	:
		number (int)
		
	Function return :
		string
		
 --->

<cffunction name="numberToLetter">
	<cfargument name="number" default="1" required="Yes" type="numeric" />
	
	<cfscript>
		
		letterRangeStart = 96;
		
		if ( arguments.number LTE 26 )
		{
			return chr( arguments.number + letterRangeStart );
		}
		else
		{
			firstLetter = chr( letterRangeStart + ceiling( arguments.number / 26 ) );

			if ( arguments.number MOD 26 NEQ 0 )
				secondLetter = chr( letterRangeStart + ( arguments.number MOD 26 ) );
			else
				secondLetter = chr( letterRangeStart + ( 26 ) );
			
			return firstLetter & secondLetter;
		}

	</cfscript>
	
</cffunction>