Larry

In any cell enter =LOOKUP(B1,{"A","B","C","D","E"}, {1,2,3,4,5})

Adjust B1 to suit.

Can be copied down a column if the column contains letters.

Not case-sensitive.


Gord Dibben MS Excel MVP

On Thu, 19 Jul 2007 15:38:00 -0700, Larry
wrote:

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.