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!
================================================== ===

"john mcmichael" wrote in message
...
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?