How do I extract the left most word in a Column?
I'm looking for a formula to extract the left-most word form a column that will have different character lengths.
Looking at the example below:
- Sometimes there is a / in front of that left-most word
- Sometimes its just a single word
- Sometimes there is a < in front of the left-most word