Separating Name and Address Phone Number with Odd Delimiter

I have the following text, in which I need separated into three columns.

Column A) Company Name
Column B) Address
Column C) Phone Number

I was thinking perhaps I could replace "-------" to just one "-" and use that delimiter to separate the phone number.
Then Use *** Company Name Here *** --> *Number Variable* and filter the rest..

But I don't see it being able to work.
Here is the text I'm looking to format (Mind you there is about 8,000 Records.

And, it's all formatted like below. (Company Name, phone number being on different lines and phone number being separated by dash's

Looking for a all-in-one formula if at all possible.

Please Login or Register  to view this content.

Screen Shot 2013-03-18 at 7.10.22 PM.png

Everything works great except for this.

Is there a way to remove all "-" Characters in that formula?

Sorry about that, sometimes I just assume everyone knows what I'm talking about without explaining. Haha..

Using this formula in column B) =LEFT(VARIABLE,MIN(FIND({0,1,2,3,4,5,6,7,8,9},VARIABLE&"0123456789"))-1)

It's producing the correct results. (Company Name)
However, there is a trail of "-----" at the end of the company name (see new photo)

\1

Simply amazing, wonderful job buddy!! I Appreciate every bit of time and effort you put into helping me!!

I can't thank you enough!

Works awesome!