Combine ifelse + locate; is it possible?

Update
I was able to do it, special thanks to SimonW. In addition I recommend seeing this from 4:32 forward. How to use String Functions within Calculated Fields

1 Like