the "value" is giving the error......in your sample only the 1 is true number..all are text
=TRIM(MID(SUBSTITUTE($A1,";",REPT(" ",LEN($A1))),LEN($A1)*(COLUMN()-2)+COLUMN()-1,LEN($A1)))