L1B | 1 |
L1P | 2 |
L1A | 3 |
L2B | 4 |
L2P | 5 |
<tbody>
</tbody>
Hi everyone
I am attempting to create a formula to convert information in the first column to a numerical value in the second column. Basically I have 5 different codes and each one needs to be converted into a numerical value in the next column. For example L1B becomes '1' L2P becomes '5'. Is there a way to do this?
Many thanks
Kayferz