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

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