Efficient way for converting Yes/No to 1/0 in Excel or SPSS

Question

I am trying to find an efficient way for converting yes/no to 1/0 in Excel. Since I am doing the data analyzing at SPSS. Or if there is a way converting YES/NO to 1/0 in SPSS directly?

Answer 1

Try this syntax in SPSS:

This will create a new field with 1 and 0. Also keep in mind that it's case sensitive.

numeric boolFieldName(f1).

recode ynFieldName ("YES" = 1) ("NO" = 0) into boolFieldName.
execute.

Answer 2

If a cell contains yes or no (say cell A1) then in another cell enter:

=IF(A1="yes",1,0)