Sunday, April 18, 2021
Home Tags Convert

Tag: convert

Convert a Letter to a Number

I am looking for a formula I can place in a column that will convert a letter to a number value. For instance, s=1, m=1.5, L=2.5. I want it to be a continous rule for the column, leaving find and replace not feasible. To solve this problem the built-in vLookup function can be used.