demerging add-in

[dinesh rekulapally]

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

 

[isabelle]

hi,

if the delimiter is comma "," then;

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

otherwise change the comma "," to another delimiter