Re: Replacing a string of words with a single number

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.