Quote Originally Posted by tigeravatar View Post
@dgagnon, Your formula finds the left-most space and returns everything to the left of that.
based on his example i misunderstood the ask, the formula provided by tigeravatar should work for what you are trying to do.