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]

How about

=LET(a,REPLACE(A2,1,FIND("- ",A2)+1,""),LEFT(a,FIND(" ",a)-1))

 

[parvares]

How about

=LET(a,REPLACE(A2,1,FIND("- ",A2)+1,""),LEFT(a,FIND(" ",a)-1))

Sorry, I haven't got Excel, is there a similar formula working on Google Sheets?
Thanks very much!

 

[Fluff]

When asking questions for any spreadsheet other than Excel you need to make that clear. Also such questions should be posted in the General Discussion & Other Applications section of the board.

I have done that for you this time.

 

[Fluff]

How about

=LEFT(REPLACE(A2,1,FIND("- ",A2)+1,""),FIND(" ",REPLACE(A2,1,FIND("- ",A2)+1,""))-1)

 

[parvares]

How about

=LEFT(REPLACE(A2,1,FIND("- ",A2)+1,""),FIND(" ",REPLACE(A2,1,FIND("- ",A2)+1,""))-1)

I apologize for not having pointed out. I tried your formula:

=SINISTRA(RIMPIAZZA(A2;1;TROVA("- ";A2)+1;"");TROVA(" ";RIMPIAZZA(A2;1;TROVA("- ";A2)+1;""))-1)

but it gives me the place of publication, not the publisher.

 

[Fluff]

In that case what should be returned (and please don't say the publisher)?

 

[parvares]

In that case what should be returned (and please don't say the publisher)?

In C2 should not return Bari (place of piublishing) but Laterza (publisher); in C3 should not return Roma but Cooper...

 

[Fluff]

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))

 

[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))

Wao, great! Is this formula working on MS Excel too (I want to try it at work)?
Thanks again!!!