Forum Discussion

Solisloz's avatar
Solisloz
Copper Contributor
Feb 02, 2021

Tex to number

Good day!
I can't find a formula that converts a text to a number, for example if in a cell it says "always" I want the number 4 to appear right away and if in that cell it says "almost always" that 3 appears in the next cell, that is, change the value according to the word in another cell.
Is there a formula like that?
excel
Formulas and Functions

1 Reply

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Feb 02, 2021

    Solisloz 

    Create a small lookup table, with the descriptions in the first column and the corresponding number in the second column You can then use VLOOKUP:

     

     

    The formula in H2 is

     

    =VLOOKUP(G2,$A$2:$B$6,2,FALSE)

     

    This can be filled down.