You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
-
I had this the other day. You can paste the text into Excel and then do 'text to columns' and specify the delimiter.
Or Data --> From Text/CSV, which imports data from an external file as a query.
I didn't understand why you don't want to use Power Query, as you can clean the data in that, but Get Data does create a 'query' underlying the table.
I've got a CSV file that is semi-colon separated but also has commas in the numbers.
If I just try and open it in Excel it assumes it is comma separated and screws up.
In years gone by you could import a text file into Excel and choose the delimiter. Now I can only find the option to do that if I import it into power query and I don't want to do that as I'll need to clean all the file. Any idea where the option to just bring a text file into Excel has gone?
This happens to me about once a month (different files) and I bumble around looking and then give up.