I think I need an IF & RIGHT formula please. I have like below where I need the formula to say if the last 2 letters are LH or RH then the number 1, if there is nothing then the number 2. Thanks
<colgroup><col></colgroup><tbody>
Suspension Arm-LH
Suspension Arm-RH
Ball Joint
</tbody>