I have text file with all the data in column A, with fields delimited by a
carot ^.
When I convert Text to Columns using the carot as the delimiter it works ok,
except Excel leaves a duplicate of the last row of data, undelimited.

My business customer thinks its a fault of the query being run beforehand,
but I've pointed out the results before and after Excel does it's thing.
Still, they want a solution that doesn't duplicate the last row.

Any thoughts ?