ducktapeonmydesk
New Member
- Joined
- Jul 5, 2017
- Messages
- 14
I have a workbook that gets automatically emailed to me every morning. I save this file to a folder on my computer and have several power queries that use this workbook as the data source.
If I drag the workbook from Outlook to my folder, open the file, and then save it, everything works as it should.
However, if I simply drag it over without opening and saving the file, there are trailing spaces in the workbook.
These trailing spaces mess with the power queries I have built. I could go in an and add a trim function to each query but 1) I shouldn't have to do that and 2) I don't want to do that.
How do I get these trailing spaces removed without having to open and save the workbook?
If I drag the workbook from Outlook to my folder, open the file, and then save it, everything works as it should.
However, if I simply drag it over without opening and saving the file, there are trailing spaces in the workbook.
These trailing spaces mess with the power queries I have built. I could go in an and add a trim function to each query but 1) I shouldn't have to do that and 2) I don't want to do that.
How do I get these trailing spaces removed without having to open and save the workbook?