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.
--
Regards,

Dave


"john mcmichael" wrote:

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?