MS Excel / VBA help thread

You are reading a single comment by @infmz and its replies. Click here to read the full conversation.

•

Drakien in reply to @aggi

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.

•

infmz in reply to @Drakien

I was going to suggest this. You can import the data from the csv and then do text to columns and pick the ;. That should preserve your values with commas in them.

These days I format all my tables using some scripting language, so not sure exactly where these options are buried.

About

Avatar for infmz @infmz started