pull out text between 2 symbols in a string within a cell

I have a column of cells that contain a long string of characters....I need to pull out text from this string and put it in subsequent columns. The symbol I am concerned with is >> For example.

If this string is in the first cell in column A:
>>abcd>>defgh>>ijkl

I would want a formula to return abcd in column b, defgh in column C, and ijkl in column d

>>this is a test>>make it work

in this example I would want "this is a test" returned in column B, and "make it work" ruturned in column C

>>frustrating

In this example, I would want "frustrating" returned in column B


any ideas?

Thanks in advance!

Hi..

Select the entire column containing this text...

Click on Data --> Text to column

Select Delimited Radio button

Click on next...

Check other and in small box type >> Click on Finish

You need to also check the option to [x] Treat consecutive delimiters as one on the Step 2 of Text To Columns wizard.