Forum Discussion
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...
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.