Forum Discussion
Convert Date and Time stored as text
Good day, I have date and time columns extracted from a source and cannot set the correct excel formats from the source. So, the extract comes through as text e.g. "6/22/2022 12:01 PM" in one cell. I...
HansVogelaar thank you, that splits the columns well. the first column (the date) appears in the correct format. The second column (the time) needs further conversion, thank you!
If you select Delimited and turn off all delimiters, the date and time should end up in a single cell.