find and split

[mrinal saha]

Just want to extract the 2010 MBIP from this string

IP III Co-Investors (2010 MBIP)

i know there is a way using substitute and am not good at that

thankss
Mrinal

 

[VoG]

Try

=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)