Lets say i have a wall of text that looks like this, all of it in 1 cell
What formula do I use to extract the latest date from this string? In this example, the ideal result will be 02/05/2014
Some considerations:
Code:
XXXXXXX ABC 22/04/14, AAAAAAAAAAAAA ABC 17/04/14, FFFFFFF ABC 01/04/14, TGHYTG ABC 22/04/14, HFFA AGF 02/04/14 & 02/05/14.
What formula do I use to extract the latest date from this string? In this example, the ideal result will be 02/05/2014
Some considerations:
- the wall of text can be very very long
- the desired output date can be anywhere in the string, it could be at the start one day and at the very end the next, it can be hidden behind an & or maybe not.