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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - convert "yes" and "no" to "1" and "0", respectively (https://www.excelbanter.com/excel-worksheet-functions/74919-convert-yes-no-1-0-respectively.html)

dcses

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

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.

Dave Peterson

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

Edit|replace?

dcses wrote:

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.

--

Dave Peterson

Kevin Vaughn

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

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

"Dave Peterson" wrote:

Edit|replace?

dcses wrote:

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.

--

Dave Peterson

All times are GMT +1. The time now is 10:32 AM.