Split cells before and after >> and copy the data to column A +B

I have data in column G3 in this format 10, 11, 12, 15, 21 >> 4, 0, 14, 6, 3 about 2400 rows ....I want a macro to simply split cell G and copy the values to column A and B. See sample attached. Rep given for a solution -many thanks

FYI - I used Data; TextToColumn to Create Macro. It will first Clear out anything in Columns A & B, then YOU MUST BE IN TOP CELL OF WHERE YOU WANT TO SPLIT ITEMS! It is splitting when it sees '>' or multiple symbols of '>' and puts into Cell A1. You can perform this without Macro help too! (Use Alt + F8 to locate the only macro in workbook.

FYI - I used Data; TextToColumn to Create Macro. It will first Clear out anything in Columns A & B, then YOU MUST BE IN TOP CELL OF WHERE YOU WANT TO SPLIT ITEMS! It is splitting when it sees '>' or multiple symbols of '>' and puts into Cell A1. You can perform this without Macro help too! (Use Alt + F8 to locate the only macro in workbook.

Originally Posted by queuesef

FYI - I used Data; TextToColumn to Create Macro. It will first Clear out anything in Columns A & B, then YOU MUST BE IN TOP CELL OF WHERE YOU WANT TO SPLIT ITEMS! It is splitting when it sees '>' or multiple symbols of '>' and puts into Cell A1. You can perform this without Macro help too! (Use Alt + F8 to locate the only macro in workbook.

Works like a champ well done great coding rep given for your help...This is marked solved thanks again queuesef