Splitting a cell

Hi all,

I’m currently processing a java export where I’ve got a column for activity code as shown below

These represent activity codes that are assigned to tasks in asta powerproject

What I’d like to do is split the cell into 01 xxxx, 02xxxx all the way to 14. I tried to use a cell splitter by comma however there are instances where you can assign more than 1 codes which means split by comma doesn’t work

How would you split the cells?

I’ve attached a dummy excel file.

dummy data.xlsx

Any help would be greatly appreciated