If you post a link to an upload site (like 'box.com') so we can see the
text file contents, it will go a long way toward providing you with a
solution. Also, show an example on an Excel sheet of the results
expected for the sample text file you provide. Put both in a zip file
and post a download link...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion