Hi


I have in a cell A1 an address e:g 103, North Road, Qw12 5rw

I know you can use the Concatenate function to merge things togethe in a
cell but can i do it the opposite way so i end up with the 3 in differnet
cells such as A2 103 A3 North Road, A4 Qw12 5rw ?

Many thanks for looking