Yes, but you will need to reverse the concatenation formula, and you will
need to have some sort of identifier to grab hold of. For example
=A1 & "~" & B1
can be reversed with
=LEFT(C1,FIND("~",C1)-1)
and
=MID(C1,FIND("~",C1)+1,32).
unfortunately each formula will need to be tailored, not hard and fast rule.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"pys" wrote in message
...
after i have used concatenate on an excel spreadsheet, is there any way i
can
deconcatenate this?
Many thanks
|