The Text to Columns functionality divides text contained within a solitary column into multiple columns using a designated delimiter, such as a comma or space. This even holds true for dates formatted ...
Press Ctrl+; to insert the current date. Press Ctrl+Shift+; to insert the current time. Press Ctrl+; > Space > Ctrl+Shift+; to insert the current date and time together in the same cell.