Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,783
- Office Version
- 365
- Platform
- Windows
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
[TABLE="width: 190"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Suspension Arm-LH[/TD]
[/TR]
[TR]
[TD]Suspension Arm-RH[/TD]
[/TR]
[TR]
[TD]Ball Joint[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 190"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Suspension Arm-LH[/TD]
[/TR]
[TR]
[TD]Suspension Arm-RH[/TD]
[/TR]
[TR]
[TD]Ball Joint[/TD]
[/TR]
</tbody>[/TABLE]