VBA - loop help in Seperating the data......

[malleshg24]

Hi Team,


I have a data in Column A of sheet1, I retrieve the data from text file,
in middle somewhere i get lines of Dashes. here task is to seperate the data and paste in different Columns starting C.


From below I want the data in 4 Columns except dashes. Thaks in advance.




ex


AAAA
AAAA
------------
BBBB
BBBB
-------------
CCC
CCC
CCCC
CCC
---------
DDDD
DDD


Regards,
mg