reverse concantination

[Guest]

can we do a reverse concantination where we take values/text that share a
common cell and break them into induvidual pieces alone in their own cells?

 

[Guest]

You can use the left, right and mid functions to pull apart the cell.

 

[Guest]

You can also use the Data->'Text to columns' feature. In this case every
record would have to be separated by a common character, like a comma. You
can choose Delimited->comma in this case.

 

[RagDyeR]

You can use
<Data> <TextToColumns>
to perform separations as long as there's something common within the data.

Post back with encompassing examples.
--

Regards,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

can we do a reverse concantination where we take values/text that share a
common cell and break them into induvidual pieces alone in their own cells?