i having problem trying figure out how can extract date , time of last correspondence in string of text on excel spread sheet.
each correspondence within each cell begins "additional information" , followed time stamp, ends in "cet" seen below (please note have replaced body text blah, blah, blah):
example cell:
additional information 4/15/15 4:29 pm cet ronald ben per phone conversation blah, blah, blah, blah, blah, blah, blah thank --------------------------- additional information 4/15/15 3:31 pm cet ben inspected blah, blah,blah, blah, blah, blah, blah, blah, blah, blah, blah --------------------------- additional information 4/13/15 8:02 pm cet michael hi craig per blah, blah,blah, blah, blah, blah, blah --------------------------- additional information 4/13/15 7:19 pm cet craig hello michael, blah, blah,blah --------------------------- additional information 4/13/15 2:42 pm cet blah, blah,blah --------------------------- additional information 4/10/15 10:46 pm cet mark hello craig, blah, blah,blah the length of text string varies cell cell, each structured same way.
in above example last time stamp should outputted 4/10/15 10:46 pm.
i tried use regexextract function, not working reason.
any appreciated.
i'm not sure regex best solution if have static text starting each entry date/time string can located , peeled out. cdate function convert both date , time portions in single stroke.
mydatetime = cdate(mid(range("a1").value2, 23, 21)) while regex may make nice solution more dynamic text entries, isn't necessary here.
