How to read a data separated by a comma in one excel column

excel

#1

image

I have this one excel column with called Invoice and it can contain multiple invoice number separated by a comma. I want to be able to read the invoice numbers inside the column individually and assign it to a variable.

Please help me


#2

@adolf.moncawe Convert that column value to string and split it with respect to ,(comma). Then all invoice numbers are separated.