# How do I convert text answers to numeric

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. ## Re: How do I convert text answers to numeric

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" <Tonny@discussions.microsoft.com> wrote in message news:FC1432D7-C3A5-4493-8F6B-1D3D1F78F567@microsoft.com...
> 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. ## Re: How do I convert text answers to numeric

On Thu, 29 Sep 2005 02:56:02 -0700, "Tonny" <Tonny@discussions.microsoft.com>
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. ## Re: How do I convert text answers to numeric

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

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1