• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 363
  • Last Modified:

Text to columns missing last row

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?
0
pmcinc
Asked:
pmcinc
2 Solutions
 
NBVCCommented:
Maybe the ERP is dumping the last row differently formatted?

If he selects just that last row and performs the TEXT to COLUMNS, does it work as expected?
0
 
Jignesh TharSenior ManagerCommented:
Can you sent list of steps to replicate this?
0
 
pmcincAuthor Commented:
Never mind, we found the problem.  The ERP was adding a blank row at the top which was throwing everything off by one row.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now