thedeadzeds
Active Member
- Joined
- Aug 16, 2011
- Messages
- 451
- Office Version
- 365
- Platform
- Windows
Hi Guys,
What is the best way using a formula to remove the last 2 parts of the below string from the code column to give the result in the Desired result column?
Thanks
What is the best way using a formula to remove the last 2 parts of the below string from the code column to give the result in the Desired result column?
Thanks
Code | Desired Result |
THYG / 0 | THYG |
YUHJKL / 1 | YUHJKL |
YTRFHD / 0 | YTRFHD |
THG / 0 | THG |