Extract Variable Length Text String

Justin, that should only occur the two times you mentioned. There is the string"- -"(hyphen,space,hyphen) that only occurs once if that helps!

TMShucks, Your formula worked exactly as I requested, but I just noticed another inconsistency in the way the data appears in the cells after being imported through the macro. I am trying to attach a sample workbook to show the problem(forgive me, new to the forum an trying to figure out how to attach). Some cells are original emails, and others are replies to the original emails and that adds another level of complexity to the formula!

Figured it out, here's the attachment!

Thanks for the quick replies!