On Thu, 5 Aug 2004 09:18:19 -0700, wrote:

If I pass 1 I want A returned, 2 = b, 3 = c and so forth

If your number is in A1, then =CHAR(A1+64) will give you an "A" for 1, but it
will give you a "B" for 2, not a "b".

What kind of rule do you want to use to decide between "B" and "b" as well as
for the other letters of the alphabet?


--ron