Hello
I have a list of names from one system that is in this format i.e. "JONES/JACK". I want a formula to return it as "Jack Jones". Basically I want to return any the name or names after the division symbol first, then have a space, & then return the first name. (JONES/JACK becomes Jack Jones).
Any help would be much appreciated.
Bookmarks