Excel formula to extract a date from a text string

[rachit05]

Hi,

I have the text strings in the following format in my excel sheet:

joey/ Date 08-17/2016/ the quick brown fox/On 2014-12-03, "ABC" debses/Asset category: Equity/balanced.-

Now, I want to extract the second date i.e. 2014-12-03 in a separate column from the string above. Could someone please help me as to how to go about it?

P.S. The string length varies, however the format remains the same for all entries.

Thank you in advance.

 

[AhoyNC]

If there is always a "," after the last date and nowhere else, try:

Excel Workbook
	A	B
1	joey/ Date 08-17/2016/ the quick brown fox/On 2014-12-03, "ABC" debses/Asset category: Equity/balanced.-	2014-12-03
2	34 2015-09-10 gh-.2016-04-05, rrerere	2016-04-05
Sheet

 

[rachit05]

@AhoyNC

Thank you very much for your prompt response. It worked

 

[AhoyNC]

You're welcome. Thanks for the feedback and welcome to the form.