Think the OP is simply asking how to split a text string using formulas
here.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"driller" wrote in message
...
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?