Unfortunately I have the same problem whether I open the text file in Excel,
or import  the data  using the wizard. If I import the data in general format,
I get the #NAME? error, and if I import it in text format I don't get the
error, but the numbers end up being formatted as text and I need to convert
them back to numbers.

The solution would be simple if the text and numbers ended up in separate
columns when I import the data, because then I could treat the columns
differently according to their specific content, but unfortunately there
will always be text in the same column as the numbers.

I had a personal reply from PY & Associates who have asked me to give them
the first 10 lines in the text file as an example (attached is a very
simplified sample of the sort of data involved), so I'm hoping they may have
an idea as to what I can do.