Values separated by Commas - want in separate columns, cells from original cell

I have a cell that can have any number of values separated by commas. For example:

1) EG,GH,JK
2) EG,GH,JK,l,o,2,3,4

All of these are in one column, but each cell in the column could have any number of combinations.. what I want to do is separate the data by the comma delimitted so the each value goes into a separate column to the right of the original column (or it could start from the original column itself).

For example in 1) and 2) above:

1) If Cell(1,1).Value = "EG,GH,JK", the macro would move data to Cell(1,1).Value = "EG", Cell(1,2).Value = "GH", Cell(1,3).Value = "JK"
2) If Cell(2,1).Value = "EG,GH,JK,l,o,2,3,4' the macro would move data to Cell(2,1).Value = "EG", Cell(1,2).Value = "GH", Cell(1,3).Value = "JK"

Cell(1,4).Value = "l", Cell(1,5).Value = "o", Cell(1,6).Value = "2", Cell(1,7).Value = "3", and Cell(1,8).Value = "4"

Greatly appreciate your thoughts on this! Thank you!!

I think this can be done with Text to Columns, but the array is variable depending upon how many values are separated by commas.

I got it... I removed the field info and works fine. Thanks for your thoughts!