Forum Discussion

DaceC335's avatar
DaceC335
Copper Contributor
May 17, 2024

text coding to number

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  2. Could you help me please?
Formulas and Functions
office 365
DaceC335's avatar
DaceC335
Copper Contributor
May 17, 2024
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's avatar
DaceC335
Copper Contributor
May 17, 2024
like i have yes in A1:A20 that the value 1 appears from A1:A20
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    May 17, 2024

    DaceC335 

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

    • DaceC335's avatar
      DaceC335
      Copper Contributor
      May 17, 2024
      yes as 1 in the same cell
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        May 17, 2024

        DaceC335 

        Afraid that's with VBA only. The opposite could be done with custom number format.

Resources