Return multiple strings from single cell based on "," and ";" delimiters

[togin]

Hey folks,

I'm looking for a formula that can return multiple strings from a single cell based om "," and ";" delimiters. Please see example data below.

The cell will contain X countries with an abreaviation. Countries (incl abr.) are separated by ";" and country and abr. are separated by ",".

DATA	Desired result
United States, US	US
United States, US;Canada, CA	US,CA
United States, US;Canada, CA;Mexico, MX	US,CA,MX
United States, US;Canada, CA;Mexico, MX;Brazil, BR	US,CA,MX,BR
And so on…

Any suggestions are appreciated

Tom

 

[Fluff]

How about

=TEXTJOIN(", ",,TRIM(INDEX(TEXTSPLIT(A2,",",";",1),,2)))

 

[togin]

How about

=TEXTJOIN(", ",,TRIM(INDEX(TEXTSPLIT(A2,",",";",1),,2)))

That did the job, thank you for the swift replay, very much appriciated

 

[Fluff]

You're welcome & thanks for the feedback.