Find data between characters - and between the next character... and the next...

I am using Excel 2007, and have a series of rows containing data separated by asterisks, like so:

* alpha * omega beta * delta * gamma gamma * epsilon alpha epsilon

I want to create a formula that will pull the data into columns. So basically I want a formula in columns B1, C1, D1 etc. to pull data from A1 and wind up with this:

* alpha * omega beta * delta * gamma gamma * epsilon alpha epsilon

alpha

omega beta

delta

gamma gamma

epsilon alpha epsilon

I feel like the answer is a combination of FIND and MID to strip out the data, but I am not quite pulling it off! Any help?

I have a few hundred cells with data formatted like this, and any assistance is appreciated. Thank you!

Could you perhaps provide an example of what you have and what you want? I'm not quite sure I understand your example, maybe add a file with some examples of what you would like?

Here is some sample data to show what I mean!

Try

=TRIM(MID(SUBSTITUTE($B2,"*",REPT(" ",250)),COLUMNS($A:A)*250+1,250))

Drag across and down

Perfect! Thanks so much, John!

Thank you for the feedback and rep.