<div>
Never mind, we found the problem. &nbsp;The ERP was adding a blank row at the top which was throwing everything off by one row.
</div>


Never mind, we found the problem.  The ERP was adding a blank row at the top which was throwing everything off by one row.

<div>
<div class="content wysiwyg-content">
I just moved our users to Office 2013 and one of my users says that when he tries to do a text-to-columns conversion it converts all but the last row. &nbsp;He's tried this on a number of queries dumped out of our ERP, but always with the same result.<br />
<br />
Does anyone know why this might be happening?
</div>
</div>


I just moved our users to Office 2013 and one of my users says that when he tries to do a text-to-columns conversion it converts all but the last row.  He's tried this on a number of queries dumped out of our ERP, but always with the same result.

Does anyone know why this might be happening?

Text to columns missing last row

Windows 7 is an operating system from Microsoft. Features include multi-touch support, a redesigned Windows Shell with a new taskbar, referred to as the Superbar, a home networking system called HomeGroup, and performance improvements.

Windows 7

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.