Extracting information from a comma separated list of values in one cell

I have comma separated list of values in one cell that is formatted as follows:

Apples(09-Aug-2012 11:35), Oranges(13-Jul-2012 09:35), Bananas(04-Sep-2012 16:08)

I am trying to figure out how to search the comma separated list for the latest date and return the fruit associated with it and the date time stamp into separate cells. For example if that comma separated list was in cell C1 I would like cell A1 to contain "Bananas" and cell B1 to contain "04-Sep-2012 16:08".

Hi

Try this

Please Login or Register  to view this content.

rylo