'The information in the cell orderdata = 3;890;ID117;K¤¤3;890;ID117;K¤¤3;890;ID117;K¤¤3;890;ID117;K 'The information in lines (obviously lol): 3;890;ID117;K orderdata = rs("orderdata") lines = split(orderdata,"¤¤") Dim productArray(), i i = 0 lines = split(orderdata,"¤¤") For Each x In lines arrayTemp = split(x, ";") redim productarray(UBound(arrayTmp)) productArray(i) = arrayTemp(0) i = i + 1 Next