vba code to split complex description data to their respective column

I have a sheet with complex description that consists eight digits , alphanumeric data , always 2 alphabets in a cells followed by comma and repeat same formats

but alphanumeric data and 2 alphabets may differ

The data need to be split to their respective columns that is all 8 eight digits , alphanumeric and 2 alphabets to their respective columns after each comma .

Looking a vba code that can split the data of column A. as it goes to 15000 rows of data

The data in column can vary up 8 split as expected results sample in blue of attached sheet

Is really the source file this workbook attachment or another type like a text file for example ?

This is an example , the original is not csv nor txt fie.

something like this maybe

Please Login or Register  to view this content.

Nearly on right track ,but the last two alphanumeric appears in the middle (red ) which should not be , but splitting did not work as expected on third split shows only 8 digits code

Notice also when there is leading 0 infront , it removes the leading zero.

try this

Please Login or Register  to view this content.

For the bulky data.

Please Login or Register  to view this content.

Hi Nilem,Halul and Jindon

Thanks for the solution provided , all of them works perfecto.