Hi all...

First of all thanx for posting me with the mergin add-in. On the same
lines if I have a dump of data with n number of different elements, is
there any add-in available to demerge this data based on the these
characteristic elements???

Thanks and regards
Dinesh

hi,

if the delimiter is comma "," then;

Range("A1").TextToColumns DataType:=xlDelimited, ConsecutiveDelimiter:=True, Other:=True, OtherChar:=","

otherwise change the comma "," to another delimiter


--
isabelle