I remember my original Excel, when I opened a txt file, I would be allowed to delineate where columns ended, and move the column markers around. I am using Execl 2000, and I am not allowed to set column separators, other than by specifying the delimiter character.
My problem is that I am importing an error log that only has spaces to separate columns, but also has spaces in the descriptive section that should be one column.
What happened to Excel allowing you to combine columns? Is there any way around this problem?