|This will work for your specific example|
I'm assuming that you'll want to do this with more than just that string, so you may need to use a combination of text functions, such as LEFT, RIGHT, MID, FIND etc. to come up with a "generic" formula that works for all strings.
On the other hand, there may not be a single formula that works for all of your data.
Perhaps if you posted a few more examples, we might see a pattern that will help lead us to a single solution.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.