View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default 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))