ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   demerging add-in (https://www.excelbanter.com/excel-programming/444581-demerging-add.html)

dinesh rekulapally

demerging add-in
 
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

demerging add-in
 
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



All times are GMT +1. The time now is 11:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com