To date, as far as I know there is no simple function. The solution is to build your own function in Visual Basic which is part of Excel, and then use that function in a standard way, as if it were built-in, by picking it from the user defined functions group on the function selection menu. This good link explains how.http://support.microsoft.com/kb/213360
Now, if it's something as simple as the 1-10 example, a lookup table, or a bunch of nested IFs would do the job: =IF(A1=1,"one",IF(A1="2","two", ... , IF(A1="10","ten","Not translated")))))))))) <-- 10 close parenthesis for every one opened
Edited by tos226, 04 October 2007 - 12:11 PM.