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

Similar Threads

Running SPSS-Syntax using Excel VBA (Excel 2013) 0
Factor Analysis 1
Convert multiple series into single series 0
How do I convert text answers to numeric 3
recode variable 1
Convert a Yes/No/NA response to a # value or % 2
moving a column of data from excel to spss 1
SPSS data and Access 2007 4

Top