HOW DO I DECONCATENATE

[Guest]

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

Many thanks

 

[Frank Kabel]

Hi
try 'Data - Text to columns'

 

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