Forum Discussion
Trying to convert text entries to a numerical value
I have a column of 20 cells. Each cell can have 1 of 10 possible entries. Each entry has a numerical value.
I am having trouble building a formula to search a table with this information to assign the numerical value to the entries.
2 Replies
Rickwelsh The numbers were probably entered as text or the cells were formatted as text before you entered the numbers . First make sure that the column is formatted as Number. That may resolve the issue. If not, try Text-to-Columns (TTC) on the Data ribbon. Select the column of numbers, select TTC and select Finish. If that doesn't work either (and since you only deal with 20 numbers), I would just select each cell, press F2 and Enter. That takes about 15 seconds and you are done.
Riny,
I solved the problem using the LOOKUP function. I built a 2 column table with the text values in one column and the numerical values in the second column. I compared each survey item to thevfirst column and the software found the numerical value in the second column.
Thank you for your suggestion.
It worked nicely. I just pastef the formula into
K
UP
