Hi,
Had a macro that worked, they have now changed the data.
I have a column that can contain a name with the following after the name , space, then (Team Member)
ie George Smith (Team Member)
The next cell may have up to 6 names, each with (Team Member); after each name
Gary Wing (Team...