I have looked at other questions but haven't quite found the answer I need.
I have a column with data in it split by delimiter ; 1;4;10;23; etc.. each row could have anything from 1 to 26 items in that column all split by delimiter
I have 26 columns set up to take the data one column for each item.
How do I get the split data into each column !!
So for example: my delimited data 1;3;15;23 is in field C2
I have columns M2 N2 O2 etc..up to 26 fields waiting for the info.
in field M2 I would like to see 1 in field N2 I would like to see 3 In field O2 I would like to see 15 etc.. etc.. where there is no data to fill (so in this example Q2 would have nothing, I would like to see either 0 or blank don't mind which.
Hoping you can help
Thanks in advance
I have a column with data in it split by delimiter ; 1;4;10;23; etc.. each row could have anything from 1 to 26 items in that column all split by delimiter
I have 26 columns set up to take the data one column for each item.
How do I get the split data into each column !!
So for example: my delimited data 1;3;15;23 is in field C2
I have columns M2 N2 O2 etc..up to 26 fields waiting for the info.
in field M2 I would like to see 1 in field N2 I would like to see 3 In field O2 I would like to see 15 etc.. etc.. where there is no data to fill (so in this example Q2 would have nothing, I would like to see either 0 or blank don't mind which.
Hoping you can help
Thanks in advance