"driller" wrote:
....
D1:=A1
E1:=B1

Ahh, but of course. But do you think that's what is actually asked here? See
the OP's subject line. Sometimes, one has to read subtly beyond the obvious
that's posted.

This particular line in the OP was also key:
But how do I UNconcatenate it to its original form of cell A1 & B1? ie 1
cell become 2 cells and it is formula base.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---