It seems there are some formatting problem here, I can't get the table format correct, so I attached a screenshot on preview.

CodePudding user response：

In B1 write this formula and drag it to the right and down.

=MID($A1;COLUMNS($B$1:B1);1)

Change semicolon to comma first, if your Excel version uses commas instead.