If you are only going to split into 2 cells then you could put this formula in the first cell to return the [John] part:
and this formula in the next cell to return the right-hand part
Did this solve your problem?
Sorry this didn't help.
106 people were helped by this reply