Forum Discussion
Solved
Split data from one column into specific columns
Hello I need to split data from one column in excel to specific columns, depending on what numbers are contained in the combined one. i.e. for each row, I need to split the comma separated data ...
When
=IFERROR( FILTERXML( "<t><s>"&SUBSTITUTE( $C3,",","</s><s>")&"</s></t>","//s[.=" & RIGHT(D$2, LEN(D$2) - FIND(" ",D$2) ) & "]"), "")
Thank you! It works perfectly, except that when I reach values of 10 and more, it is not recognising the 10, 11, 12 etc. as whole numbers, and is populating code 10 column with a 0, code 11 column with 1, code 12 column with 2, code 13 column with 3 etc, etc...
When
=IFERROR( FILTERXML( "<t><s>"&SUBSTITUTE( $C3,",","</s><s>")&"</s></t>","//s[.=" & RIGHT(D$2, LEN(D$2) - FIND(" ",D$2) ) & "]"), "")- Perfect, thank you so much!!!
sarahhcob , you are welcome