I've a cell with concatenated values separated by commas like this -
<TBODY>
10,20,AA,BB,30,40, CC, DD</SPAN>
</TBODY>
I need them to split into 2 cells based on criteria
If 10,AA,CC show it in a new cell as -
<TBODY>
10, AA,CC
And if the rest (20,BB,30,BB, DD) then in another cell.
Any...