Q: I have noticed that when I use Excel’s Text to Columns tool to parse text data, sometimes it automatically recognizes the commas, spaces, quotes or other separators, and other times it does not.
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.