Forum Discussion
Separating Date & Time for Function
Hello, dsmith5740
In addition, you can use Power Query to Separate the Date & Time
Click anywhere in the data and execute CTRL + T
Check my table has headers and click OK
In the Get & Transform, click on From Table
In the Power Query editor, click on Split Column in the Home tab
Select By Delimiter
Select Space from the drop-down
Check Left-most delimiter
Click OK. From the caption below, we have the date and time splited into two columns
Then, you can choose Close & Load to load the result back to excel
Hello, dsmith5740
In addition, you can use Power Query to Separate the Date & Time
Click anywhere in the data and execute CTRL + T
Check my table has headers and click OK
In the Get & Transform, click on From Table
In the Power Query editor, click on Split Column in the Home tab
Select By Delimiter
Select Space from the drop-down
Check Left-most delimiter
Click OK. From the caption below, we have the date and time splited into two columns
Then, you can choose Close & Load to load the result back to excel