Enter this formula in B1 and pull it to the right until you see blanks

=TRIM(MID(SUBSTITUTE($A1,";",REPT(" ",255)),(COLUMNS($A:A)-1)*255+1,255))