I used to import tab separated text files as a range in previous version of Excel. I can still do it by enabling the "legacy" import wizard in Excel 2019; I can't find an easy way to achieve my end with the new power query of Excel 2019. I systematically get an Excel table which is not what I want. Although it is possible to convert the table as a range afterwards (In Design -> Convert as range); this will break the connection to the text file and so it won't refresh if the file change. Anyone has a solution? There are lots of options in this new power query I may have missed something.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Import text as range in excel 2019
- Thread starter Diolu
- Start date
-
- Tags
- import .txt
Excel Facts
Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Similar threads
- Solved
- Replies
- 1
- Views
- 570
- Replies
- 1
- Views
- 699
- Replies
- 4
- Views
- 801
- Question
- Replies
- 1
- Views
- 1K
