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


G

Guest

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

Advertisements

D

Dave Peterson

Edit|replace?
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.
 
Ad

Advertisements

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top