Forum Discussion
Help for the beginner please - converting text to a value
Hi, Just starting out so this may be easy. If a cell contains text and I want to convert the text phrase to a number, how do I do that? Here is the table: If the phrase in column E is "Moderat...
Hello,
You can build a lookup table with all the different categories and their corresponding values. Then you can us a Vlookup() function to look up the value. Consider this screenshot:
The formula in cell C2 is =VLOOKUP(E2,$L$1:$M$6,2,FALSE) and copied down. I put in some dummy numbers in the lookup table, which sits in column L and M. The lookup table can be on a different sheet, of course.