Thread
:
Convert letters into numbers. i.e. ABCD = 52
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Richard Buttrey
Posts: n/a
Convert letters into numbers. i.e. ABCD = 52
On Fri, 9 Dec 2005 05:52:01 -0800, "Rhapsody 1234" <Rhapsody
wrote:
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!
Just as a matter of interest, what are the values that you want to
apply to A,C,G & T?
Aren't the ASCII code sums going to be non unique.
i.e CCCCCC & AAAAGG both sum to 204
In which case aren't you going to find problems with any numerical
analysis?
Rgds
Richard Buttrey
__
Reply With Quote