Replicate publisher in column C for Google Sheets

[parvares]

Hello, starting from this sheet with column A (title, responsibility, publisher) I would need a formula that extracts only the publisher in column C. I used this formula:

= LEFT (MID (A2, FIND ("-", A2) +1, LEN (A2)), FIND (",", MID (A2, FIND ("-", A2) +1, LEN (A2))) ) -1)

but column C gives me the place of publication and the publisher. I would like instead only the publisher.

Many thanks!!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[parvares]

Ok, how about

=MID(REPLACE(A2,FIND(",",A2),LEN(A2),""),FIND(":",REPLACE(A2,FIND(",",A2),LEN(A2),""),FIND("-",REPLACE(A2,FIND(",",A2),LEN(A2),"")))+2,LEN(A2))

Sorry, If column A had this type of formatting could the publisher be obtained?
In this case it is placed between the last closing round parenthesis ) and the next comma.
Thanks much!

 

[parvares]

Replicare Autore, editore

Foglio1 TITOLO / RESPONSABILITA' () EDITORE, ANNO,AUTORE,EDITORE Cambiare le ossa Condividi di Barbara Baraldi (Autore) Giunti Editore, 2022 Storia della tecnologia. Vol. 2\2: Le civiltà mediterranee e il Medioevo. Condividi Alfred R. Hall (Curatore) Eric J. Holmyard (Curatore) Charles Singer ...

docs.google.com

 

[Fluff]

How about

=LEFT(MID(A2,FIND("^",SUBSTITUTE(A2,CHAR(10),"^",LEN(A2)-LEN(SUBSTITUTE(A2,CHAR(10),""))))+1,LEN(A2)),FIND(",",MID(A2,FIND("^",SUBSTITUTE(A2,CHAR(10),"^",LEN(A2)-LEN(SUBSTITUTE(A2,CHAR(10),""))))+1,LEN(A2)))-1)

 

[parvares]

Great, thanks again, very kind from you!!

 

[Fluff]

Glad to help & thanks for the feedback.

 

[parvares]

Sorry Fluff, the very last question. If I wanted to extract from the last file the responsibilities (author, editors, but not the translators!) placed between the writing (condividi) and the last closing round parenthesis )? Thanks again!

 

[Fluff]

How about

=MID(LEFT(A2,FIND("^",SUBSTITUTE(A2,CHAR(10),"^",LEN(A2)-LEN(SUBSTITUTE(A2,CHAR(10),""))))-1),SEARCH("condividi",A2)+10,LEN(A2))

 

[parvares]

How about

=MID(LEFT(A2,FIND("^",SUBSTITUTE(A2,CHAR(10),"^",LEN(A2)-LEN(SUBSTITUTE(A2,CHAR(10),""))))-1),SEARCH("condividi",A2)+10,LEN(A2))

Nearly perfect! I was looking for excluding the translator from the responsabilities. In other word I would like only the text in black bold fron the file...

 

[Fluff]

That will be difficult as there is no obvious way to determine what to return.