mid/left/right?!?

[Fazila]

I really should know this but I can't seem to figure it out, how can I extract the subject name from the following? The name will always be between "):" and ":"

2019: Year 10 TA1 (31 Oct 2018): English Literature: Effort: Name

The bit I want to extract is English Literature.

Thanks again

 

[Scott T]

Try

=MID(A1,SEARCH("):",A1,1)+3,SEARCH(":",MID(A1,SEARCH("):",A1,1)+3,9999),1)-1)

 

[Fazila]

Thank you Scott that worked perfectly!