Um... Ick.





I found an OLD discussion where this question got asked - somewhere around 2015 - or about 75 years ago in computer years. They got the same answer, but I figured after ALL THAT TIME Excel MUST have something a whole lot better than brute force, hoping you hit the right columns, during an import of a file that should be formatted so you don't have to import it.....


<heavy sigh>

It does, Power Query. Set it up well and you may not even have to click anything at all for it to update correctly.