Forum Discussion
Replacing a string of words with a single number
I work with a lot of outcome data from a survey that has words as the typical response to questions. I need to convert those words to a number value so that I can analyze the data (example: "I really...
Yes you can/should look at XLOOKUP and create a table for text strings and how they should be converted. You can even use wildcard characters to make it more flexible and robust.