Forum Discussion
Convert text to excel spread sheet
Recently upgraded to windows 10 and office products 365 which includes excel 2019. All working properly. However when I try to import a .txt file (which I have attached) into excel, it loads the en...
Ah, yes I tried to attach a text (.txt) file without success. I do not quite understand when you say "load into Excel Power Query".
I open a blank excel spread sheet.
I select From Text/CSV in the Data.
I browse to the .txt file from the desk top.
I click OK and . .
I get an excel spread sheet with every entry in the text file as a column (2500 of them) in the 1st row.
It's quite a wide spread sheet, but not what I need.
Well, it is power query that will do the job... Moreover, Im surprised that you have 25,000 columns!