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