View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default change letter to number add number

a-i = 1-9 ==== j-r = 1-9 ====== s-z = 1-8

a=1, b=2, c=3, d=4, e=5, f=6, g=7, h=8, i=9,
j=1, k=2, etc..................

objective is to write a name like ANGEL then formula
ANGEL = 15753 = sum it to 1+5+7+5+3=21=3

Result is ANGEL(Cell A1) = 3(cell B1)
user types ANGEL in column A gets result in column B

Thanks