How to Separate Date and Time in Excel using Text to Columns, Formula & Power Query

Microsoft Excel Tips and Tricks

In this method I show three different methods for splitting date and time in Microsoft Excel.

Credit Chester Tugwell