HOW DO I DECONCATENATE

P

pys

after i have used concatenate on an excel spreadsheet, is there any way i can
deconcatenate this?

Many thanks
 
B

Bob Phillips

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)
 
Top