•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power Query import from EndNote txt file
Our take
If you're looking to streamline your data management process, Power Query offers a powerful way to import tab-delimited text files from EndNote. However, it can be challenging when rows aren't importing correctly. If you've encountered issues with data appearing in the wrong columns, you're not alone. Many users face similar hurdles when transitioning data. By sharing a screenshot of your specific problem, the community can provide targeted guidance to help you resolve these discrepancies and enhance your Excel experience.
Hi all, I'm a mediocre Excel user and need to import a data file (tab delimited txt) from EndNote. I'm using the Power Query as recommended and it almost works, but i have some rows that are imported incorrectly. I'll post a screenshot where the parts in the wrong column are noted. Any help is appreciated!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience