Forum Discussion
tony9i9i9i
Sep 15, 2022Copper Contributor
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...
lcmcbh
Sep 15, 2022Copper Contributor
tony9i9i9i Assuming the data is in A1 and there aren't any strange spacing issues in the data,
This will get the date:
=LEFT(A1,FIND(",",A1)+5)+0
This will get the time:
=MID(A1,FIND(",",A1)+7,99)+0
Set the formatting accordingly.