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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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

Similar Threads

Running SPSS-Syntax using Excel VBA (Excel 2013) 0
How to convert OST to PDF? Simple Methods 4
How to convert a .msg File? 2
Best Ways to Convert OST to PDF? 4
Spss verse excel 5
Factor Analysis 1
How Can I Convert MBOX to HTML File? 2
Convert multiple series into single series 0

Back
Top