reverse concantination

J

john mcmichael

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?
 
D

DaveB

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.
 
R

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?
 
Top