Forum Discussion
How can I save a fixed field definition when importing into Excel?
I frequently need to import the same fixed field file into Excel every week. During the Open operation, I'm selecting a text file. I'm presented with a window to select the heading column, the row...
I frequently need to import the same fixed field file into Excel every week
Get & Transform aka Power Query is your friend. Assuming you run >/= 2016 on Windows or 365 on Mac... - Info. recommended in Welcome to your Excel discussion space! as nobody on this community has a crystal ball 🙂