Forum Discussion
Issues with changing text format string to date format on data imported from msproject.
Good evening, I work with Excel 2013. I have this text format "2017 March 29 17:00" to convert to a date format ( wihtout the hour) in Excel. This date comes from a microsoft project saved in Ex...
Hi pbosisio,
I suggest use following formula:
=LEFT(A1,SEARCH(" ",A1)-1) => 2017 (year)
=MID(A1,SEARCH(" ",A1)+1,SEARCH(" ",A1,SEARCH(" ",A1)+1)-SEARCH(" ",A1)-1) => March (month)
=MID(A1,SEARCH(" ",A1,SEARCH(" ",A1)+1)+1,SEARCH(" ",A1,SEARCH(" ",A1,SEARCH(" ",A1)+1)+1)-SEARCH(" ",A1,SEARCH(" ",A1)+1)-1) =>29 (day)