| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting Letter to Numeric Value
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Letter Grade to Numerical Value | Excel Discussion (Misc queries) | |||
| Formula involving a letter that has to have a numeric value | Excel Worksheet Functions | |||
| Vlookup using letter and numeric codes | Excel Discussion (Misc queries) | |||
| How do I assign a numeric value to a text letter | Excel Discussion (Misc queries) | |||
| Converting Letter Grades to Numeric | Excel Worksheet Functions | |||
Threaded Mode
