Dipak Bhudia on 16 Oct 2018 07:16:45
It takes TONs of time to split columns in a text file which is padded by spaces and has no delimiters. The traditional Excel Text Import allows VISUAL DELIMITING (Step 2 of 3 of the Text Import Wizard) based on a preview of the data. It is ironic that something used to be done in 3 mins in a legacy wizard now takes over 20 mins in Power Query (yes I have a lot of columns).