Hi,

I've recieved a bunch .txt files that very hard to retrieve information from. No delimiters to use at all, all information is in one cell. I've tried with notepad++ without success. The files are approx. 10 000 rows so there's noway I could handle this manually. In each of the rows there's a five digit number I want to retrive and store away. The number can be anywhere from 10000 to 99999. And is always surronded by two blanks on either side. Is there anyway for me to get this done through VBA?

This topic may have been mentioned elsewhere on this forum, but I can't find it since I don't really know what to search after.

Thanks in advance
Peter