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!