How do I use letters to represent numbers?
"excel_noob" wrote:
Subject: How do I use letters to represent numbers?
Kinda light in details. For numbers from 0 to 25 in A1, for uppercase
letters, use:
CHAR(65+A1)
For lowercase letters, use:
CHAR(97+A1)
For numbers that might be larger than 25, use base-26 arithmetic. For
example, numbers from 0 to 675 can be represented by the 2-letter
combinations formed as follows:
CHAR(65+INT(A1/26))&CHAR(65+MOD(A1,26))
|