Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I convert text answers to numeric
I want to convert some 'Yes/No' answers into numeric (i.e. Yes=1; No=0).
These will then be inputted into SPSS. How do you convert text to numeric in Excel? Thanks in advance |
#2
|
|||
|
|||
If you want to convert them in place with no fuss, you can use a
macro to work off of a selection of cells. For a worksheet solution you can insert a new column (helper column) the worksheet below is not case sensitive =IF(A1="Yes",1,IF(A1="No",0, A1)) or a variation =IF(LEFT(A1,1)="Y",1,IF(LEFT(A1,1)="N",0, A1)) --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Tonny" wrote in message ... I want to convert some 'Yes/No' answers into numeric (i.e. Yes=1; No=0). These will then be inputted into SPSS. How do you convert text to numeric in Excel? Thanks in advance |
#3
|
|||
|
|||
On Thu, 29 Sep 2005 02:56:02 -0700, "Tonny"
wrote: I want to convert some 'Yes/No' answers into numeric (i.e. Yes=1; No=0). These will then be inputted into SPSS. How do you convert text to numeric in Excel? Thanks in advance For a formula: =--(A1="yes") will give a result of 1 for Yes and 2 for No. --ron |
#4
|
|||
|
|||
One more...
Select the range to fix: edit|Replace what: Yes with: 1 replace all do the similar thing for No. Tonny wrote: I want to convert some 'Yes/No' answers into numeric (i.e. Yes=1; No=0). These will then be inputted into SPSS. How do you convert text to numeric in Excel? Thanks in advance -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Convert excel file to flat text file | Excel Discussion (Misc queries) | |||
convert a number in Excel from numeric to text, i.e. "1" to "one" | Excel Worksheet Functions | |||
How do I convert dollars and cents to text, and prefill the cell . | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |