HOW DO I DECONCATENATE
 

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

Many thanks

Hi
try 'Data - Text to columns'

--
Regards
Frank Kabel
Frankfurt, Germany

"pys" schrieb im Newsbeitrag
...
after i have used concatenate on an excel spreadsheet, is there any
way i can
deconcatenate this?

Many thanks

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