text coding to number

Question

Hello,i have a lot of similar text (like yes and no) and each yes i would like to code with number 1, and no with number&nbsp; 2. Could you help me please?

sergeibaklan · Answer

DaceC335&nbsp;
If without VBA as&nbsp;Martin_Angosto&nbsp;suggested - yes. But you may select entire sheet and replace, not a lot of time. The only don't forget to check "Match entire cell content"

martin_angosto · Answer

DaceC335&nbsp;&nbsp;Something like creating a column next to these texts and generate 1 if "yes" and 2 if "no"?&nbsp;Assuming your text range is from A1:A50:&nbsp;On B1 type =IFERROR(IFS(A1="Yes",1,A1="No",2),"")Then fill down until B50

dacec335 · Answer

Thank you Martin for reply.My goal is not to change the text to value in a different column, but in the entire sheet or cell containing Yes or No words.

dacec335 · Answer

like i have yes in A1:A20 that the value 1 appears from A1:A20

sergeibaklan · Answer

DaceC335&nbsp;
You would like to show "yes" as 1 in the same cell, or you would like to do some calculations taking "yes" as 1?

Forum Discussion

text coding to number

9 Replies

Resources