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.
 
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.
Click to expand...
 
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.
 
You must log in or register to reply here.

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 MBOX to PST Online? 3
Spss verse excel 5
Factor Analysis 1
Convert multiple series into single series 0
How do I convert text answers to numeric 3
Which is the best MBOX Converter Tool different formats conversion? 4
How do I interpret Regression alanysed data ? 1

Back
Top