How to extract latest date from single cell having multiple dates

[Kiran Deshmukh]

How to extract latest date from single cell having multiple dates and could be multiple comments

e.g. I have to extract below and would


Feb 11, 2019 1:10:09 PM: Task started "Kiran".
Mar 20, 2019 1:41:30 AM - Kiran: task started but having multiple issues
Mar 24, 2019 10:45:52 AM - kiran: "task completed".

 

[bosco_yip]

Try...............

1] Data put in A1

2] In B1, enter formula :

=LEFT(TRIM(RIGHT(SUBSTITUTE(A1,CHAR(10),REPT(" ",300)),300)),12)

Regards
Bosco

 

[Kiran Deshmukh]

@Bosco Thank you so much for your help!!! Its working!!!

But in case if we have more characters in the cell then it shows blank.

Appreciate your help!!!

 

[bosco_yip]

@Bosco Thank you so much for your help!!! Its working!!!

But in case if we have more characters in the cell then it shows blank.

Appreciate your help!!!

Hi,

Give example and more information regarding your more characters in cell case.

Remark : your data date setting appeared not the standard date format of Excel, maybe copied from other external software program file.

Regards
Bosco