Hi all,

I have a dataset with more than 70,000 rows with weather data. I need to convert my cardinal points (N,E,ENE, S, W, WSW, ect..) to degrees ( 0, 90, ec..), I am trying to automate this process. Is there anyway to do this by using Vlookup or lookup?

Thanks in advance for your help