Reading text files into excel with multiple spaces as delimiter

Hi all,
I am having some trouble importing a text file into excel by code. The Text file is space delimited, BUT there are multiple spaces and the spacing is inconsistent. Is there any way I can import the text file with this impossible layout?

Cheers

Robert

Hi,
what happens when you try to import the file choosing " space " as delimiter?

Well if I do it the hard way (manually open text file through excel) then it imports it correct. But if I do it with code and delimiter = chr(32) then it goes cracy.

Robert

Maybe publishing the code will help ?