sorry max, its not suppose to oppose your logic. The ? is will this formula
work-out when the referred A1 and B1 is not in the same workbook. lets say
that the formula exist yet the source workbook is corrupted, to have a sense
on the thread reading by other viewers. Dont you think so?

"Max" wrote:

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