How Can I Separate this Data?

[Mahwill]

Here is what I'm working with -
Nationwide Business Talk 450 03/29/11 - 04/28/11 03/29 - 04/28

The amount after Business Talk can be different, such as 2000 instead of 450.
Is there a good way to separate this so all that is left is Nationwide Business Talk 450?

I use =IFERROR(LEFT(A18,FIND("Msg",A18) + 2),IFERROR(LEFT(A18,FIND("Share",A18)+4),"DNE"))
to take care of the items listed below and it seems to work just fine. I just can't seem to get the one that has minutes to separate like it.

Nationwide Bus Talk Share 03/29/11 - 04/28/11 03/29 - 04/28
Nationwide Bus 450 Email+Msg 03/29/11 - 04/28/11 03/29 - 04/28

Any insight would be greatly appreciated.

 

[Rick Rothstein]

IF your examples are truly representative of the rest of your data, then I think this formula should work for you...

=LEFT(A1,FIND("/",A1)-4)

 

[Mahwill]

That should be work perfectly. Thank you so much. It's so simple I can't believe I didn't see that.