So if the cell A1 contains 1;7;15; 23; 99;100 then:

B1=1

C1=7

D1=15

E1=23

F1=99

G1=100

H1=""

I1=""

J1=""

K1=""

Of course the easy way to do this would be with a macro using data- text to column, but this needs to be a macro free workbook if possible. So I need a formula for each cell and could add a cell if one is needed to strip out any spaces with substitute.

Thanks for any ideas!