Are they in the same cell or do you mean each cell has either A or B or C
etc?
If there are one letter per cell and you want to sum the cells it is easy

=SUMPRODUCT(COUNTIF(A1:A10,{"A";"B";"C";"D";"E"}), {1;2;3;4;5})

will sum A1:A10


--
Regards,

Peo Sjoblom


"Larry" wrote in message
...
I have imported a text file with study participant responses that were
coded
A,B,C,D,E. In order to conduct a statistical analysis I need to convert
these to numeric values A=1, etc. I went to the CODE function but this
codes
A=65, etc.and only codes one cell at a time. What function or formula is
necessary to code for my desired values and accomplished for the dataset.
Thanks.
--
Larry