Replace text using wildcard

[mikeymay]

I have a column of text that contains some text and example of which is below
Bloggs Joe, GB Sales:Required;Smith John, GB Sales:Required;Jones Sally, GB ASC:Required;Walker, Alan, GB Sales:Required

There could be a number of combinations of the 'GB ?:Required' text and I won;t know what these text strings will be

Basically what I need to do is just have the column contain the names so the above would be as follows
Bloggs Joe, Smith John, Jones Sally, Walker, Alan

Sometimes there will only be one name as follows
Bloggs Joe, GB Sales:Required

For this I would only need
Bloggs, Joe
to be in the column

 

[mikeymay]

Sorry but I can't get this to work either....I'm wondering if I might be jumping a bit too far in to the deep end and will need to get a better handle on M code before I tackle something like this.

 

[VBA Geek]

I can show you exactly where to put it if you show me the entire M code

 

[mikeymay]

Many thanks for the offer to help. Would email work better? I can't get screen shots in my posts on here whereas I can add them easily to emails. If you're happy to do this then DM me with your email address and I'll break down what I'm doing. Thanks