Workbooks.OpenText parses out spaces?

Go to any directory where you have write access (say, something besides root).
I'm going to assume that's c:\ABC, so modify ABC below to your own directory name. Go
dir c:\users > foo.txt

Now do this - immediate window

Please Login or Register  to view this content.

A4 gets "Directory" (no trailing spaces)
B4 gets "of c:\" (no leading spaces)
My question is, what happened to the space between the word "Directory" and "of" ??
I presume that this is going to happen with the fixed width text to column command too.
I could understand it being eaten if my text-to-column processing was delimited, but this is fixed width.

AFAICT it doesn't lose meaningful characters; only spaces between words. Is this absurdity documented?

------------------
P.S. I am having to log in to xlforum way too much. It's as though I time out after some number of minutes. I do always bang the Remember Me box. Windows 7 / current Firefox

When this happens I also get an immediate error message if I was simply hitting F5 to refresh my subscription list, even AFTER entering credentials:
"Invalid Redirect URL (http://www.excelforum.com/subscription.php?folderid=0)"

I am on Windows 10 Firefox and can stay logged in permanently - are you allowing the browser to accept cookies from the EF site?

Well I hit the jackpot. Lovely to see you again. In Firefox I block Third-party tracking cookies and have "Standard content blocking" set. Could that possibly be in play? "Balanced for protection and performance. Allows some trackers so websites function properly." If xlforum uses tracking then maybe...

(Note, as to the error message, it only strikes once; then when I reenter the subscriptions URL it works. But I'm having to do 3 page loads when all I was doing was hitting F5.)

Did you try my VBA problem scenario? It's real quick and easy, for anyone.