If you have a range of cells that contain only one of these single letters:
A,B,C,D,E

Select the range of cells in question
Goto the menu EditReplace
Find what: A
Replace with: 1
Replace all

Repeat for the other letters.

--
Biff
Microsoft Excel MVP


"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