For a cell in Excel, I want to extract all the data separated by a comma into an array. But I don’t know how many data there are in a cell, so I don’t know how many loop are needed.
I think a Do-while loop can solve this. Once the array (index) becomes empty, the loop should stop.
Not sure how to write the condition.