Hello,
In my excel sheet I have a list of text values, namely the first letter of wind directions. So I have something like this:
<tbody>
A
B
SE
NNW
N
N
NNW
S
</tbody>
I want each text ( for instance SE) from column A to correspond to a numerical value. For instance...