convert "yes" and "no" to "1" and "0", respectively

D

dcses

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.
 
K

Kevin Vaughn

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.
 
Top