Forum Discussion
Date and time combined in data extract...
Hi, I've extracted some CSV data and the date and time information occurs in the same cell (some cells are empty) in such a way excel cannot recognise it, please see below, Apr 23, 2021 12:05...
Take the date out of a date and time. generic recipe =INT(date) The INT function can be used to extract the date portion of a date that also contains time (i.e., a datetime). Excel uses a system where times are fractional values and dates are serial numbers to handle dates and time. Date and time are used to calculate time.
- Thanks for the responses guys, I went with something simpler, I did four find and replaces, replacing the four digit year and its trailing space with a four digit year and a -, then I used a text function to take the text before the - and the text after the -.
