Thread: Find text within cell then display text to left
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default Find text within cell then display text to left
You're welcome. Thanks for the feedback!

If you want to extract Pittsburgh Pirates:

=MID(E2,FIND(" vs ",E2)+4,FIND(" for ",E2)-(FIND(" vs ",E2)+3))

Biff

"Jambruins" wrote in message
...
Thanks for the help. It works perfectly!


Reply With QuoteReply With Quote