View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rhapsody 1234
 
Posts: n/a
Default Convert letters into numbers. i.e. ABCD = 52

I work with DNA and would like to assign numerical values to the bases. i.e.
A = 32 etc.
Ideally, I just want to past a DNA sequence into Excel, e.g. ATGCCA and then
have a numerical display of the value obtained if these are summed. e.g. if
A=32, AA=64, AAA=96 etc.

Any way I can do this?
Thanks!