Hi

I'm writing having tried a few LEFT, TRIM, MID & FIND & SUBSTITUTE Columns to cleanse data

The text coming in looks like this (Example)

PersonA, A., PersonB, B., PersonC, C. C., PersonD, D., & PersonE, E. (2019). Lots of text here but the beginning is always the same to the year.

I can strip off the people part using

=LEFT(B2,FIND("(",B2)-1)

This gives everything before the date, Now I take out the ampersand with

=SUBSTITUTE(B3,"& ","")

I end up with something like this as a product of the filtering across columns

PersonA, A., PersonB, B., PersonC, C. C., PersonD, D., PersonE, E.

Then I get rid of the . with

=SUBSTITUTE(B3,"& "."")

Surname, A, Surname, B, Surname, C C, Surname, D, Surname, E

Then I get rid of the spaces with

=SUBSTITUTE(B3,"& " "")

It leads to this

Surname,A,Surname,B, Surname,CC,Surname,D,Surname,E

But I need to achieve this

SurnameA,SurnameB, SurnameCC,SurnameD,SurnameE

It then allows a simple one move text to columns delimited by the remaining comma.

So the question is how to remove the first and then only every other comma in a formula.

Sorry for the fragmented explanation but Ive not been able to work it out.

Thanks AI