How to split date and the time with Excel? With just to simple formulas, you can extract them in 2 different columns
Power Query is the best tool to manipulate and transform your data without a formula or script. Discover some examples here
It's very easy to extract the hierarchy of a folder and subfolders with Excel. In just 5 steps the job is done.
How to merge many Excel workbooks into a single one? This steby-step guide will explain you the technique with Excel and Power Query.
This article gives you the M Code for Power Query to return the result of the DATEDIFF function (difference between 2 dates)
This step-by-step guide will walk you through the process of split your date and time data with Power Query.