Hi
I wonder if someone could assist with a formula to reverse two sets of names in a cell please.
Scenario
I have been sent a large set of data where the names are like this
Smith Fred - Hunt George
I would like to change it to
Fred Smith/George Hunt
I've used =MID(A1&" "&A1,FIND(" ",A1)+1,LEN(A1)) before to reverse two names, but this goes beyond.
I'm not too worried about anomalies that might occur, I can manually edit them (where a middle name is introduced or a Jr or Sr is added)
Thanks for your thoughts
Neil
Bookmarks