I'm using the following MID function: =MID(I9,SEARCH(" :",I9,1)+2,SEARCH(" :",I9,SEARCH(":",I9,1)+1)-SEARCH(": ",I9,1))

Cell I9 contains: "JES Access Manager 7 2005Q4 : Deployment Example 1: AM Load Balancer, Distributed Authentication, a

I just want to extract the following: Deployment Example 1

I'm getting the #Value! Error.

What's wrong with this formula?