I have columns of data that contain account names. However, some account names contain two peoples names seperated by different characters i.e 'John & Mary' , 'Phillpe+Henry' , 'Rory and Jane'.

What I am trying to do is seperate the names.

I tried using th e following code:
Please Login or Register  to view this content.
What happens when I run it is the '&' fields are seperated but then when it goes to seperate '+' fields it puts the '&' fields back together and so on.

How would I stop this from happening?