Add semicolon to exported string values

[PAQ]

Hi experts,

Hope everyone is well! I need your help. I have a spreadsheet with a column that has multiple strings in parenthesis that I need to extract to a new column. I have managed to do this with the formula below but I can't seem to figure out how to include a separator for the data. I would like to include a semicolon or dash to separate them. Can anyone assist? Thank you.

=CONCAT(SUBSTITUTE(MID(SUBSTITUTE(SUBSTITUTE(C3, ")","("),"(",REPT("(",1000)),SEQUENCE(LEN(C3),,,2)*1000,1000),"(",""))

 

[Fluff]

Hi & welcome to MrExcel.
How about

=TEXTJOIN("; ",,SUBSTITUTE(MID(SUBSTITUTE(SUBSTITUTE(C3, ")","("),"(",REPT("(",1000)),SEQUENCE(LEN(C3),,,2)*1000,1000),"(",""))

 

[PAQ]

=TEXTJOIN("; ",,SUBSTITUTE(MID(SUBSTITUTE(SUBSTITUTE(C3, ")","("),"(",REPT("(",1000)),SEQUENCE(LEN(C3),,,2)*1000,1000),"(",""))

You are a LIFE SAVER! this worked! Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.