| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert "yes" and "no" to "1" and "0", respectively
Does anyone know how to convert "yes" and "no" to "1" and "0" in excel? I'd
like then to do analysis using SPSS. Thank you. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert "yes" and "no" to "1" and "0", respectively
Edit|replace?
dcses wrote: Does anyone know how to convert "yes" and "no" to "1" and "0" in excel? I'd like then to do analysis using SPSS. Thank you. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert "yes" and "no" to "1" and "0", respectively
Or if you prefer a more difficult solution, create a helper column, enter
this formula: =(A1="yes")*1 copy down, copy paste special values to a, and then delete the helper column. Not trying to be facetious, just looked interesting. -- Kevin Vaughn "Dave Peterson" wrote: Edit|replace? dcses wrote: Does anyone know how to convert "yes" and "no" to "1" and "0" in excel? I'd like then to do analysis using SPSS. Thank you. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
