Numbers to Alphabets
=LEFT(ADDRESS(1,20,2),FIND("$",ADDRESS(1,20,2),1)-1)
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"rk0909" wrote in message
...
Hello,
I want to create a formula where the input is a number representing a
column (e.g. 20) but i want that to be interpretted as an alphabet
corresponding
to the numbers (T in this case). Is there a conversion formula that
exists?
thanks,
RK
|