Hi there, is there a way (either formula or VB) to swap multiple names in one Excel cell?
Example of current data in one cell:
Victoria Wood, David Jones, Sharon Smith, Caroline S Petit, Martine P Smar, Elizabeth A Gilley, Alex Davies, Andrew P Collins
The format I want to convert it to (in...