Last seen: Jun 7, 2026
Hi Ammar, The order of the parameters for #date are year, month, day. You've got day, month, year. This is the correct format = Table.Ad...
It certainly does.
Hi Ammar, I presume that you are using dd/mm/yyyy? After splitting the text into 3 columns, recombine it with / as the separator. You can then ...
Hi Vinay, No workbook attached. You need to click on Start Upload. Phil
It was 20+ years ago. I don't have them any more
No worries David. I remember reading a manual on the DOS Prompt from cover to cover. I used to write a lot of batch files for things like remote ins...
Hi Bruno, How long it it taking? I've run this query against 100,000 rows and it takes a few seconds. And all you need to do is click on Refresh ...
Hi Hans, It appears to have something to do with the length of the string. If you split the string into 2, both halves encode without issue. I ...
Hi Nathan, Can you please supply your workbook. It'll be easier for me to understand what you are trying to do if I can see the sheet(s). Regar...
Hi David, If you type xcopy /? in the Command Prompt you get all the help info for xcopy that tells you what the switches do. /s Copy directorie...
It depends on what files you want to delete. If it is ALL files of a certain type or name you can use del *.XLS* /s but that will delete ALL files th...
Hi Bruno, See attached file for solution. Query result is loaded onto Sheet1. Regards Phil
Hi David, Use xcopy from the Command Prompt - much easier as it already exists. I assume you are using Windows. Click on the Start/Windows butt...
Hi Amien, You need to use Power Query to get the data into Excel from Sharepoint. That will fix your problem with dates in text format. To illus...
Hi Al, No file attached. You have to click on Start Upload to upload the file. Phil