Find Characters all in form of mm/dd/yyyy within String of Text

[jbesr1230]

Hello

I am working in excel 2010 and I have a spreadsheet with many rows of long Text, in Column A. Within each text string at some point is date which is always in the format mm/dd/yyyy. I am trying to find a formula that I could put in each cell of column B that would capture this date in column B. Any help is greatly appreciated.

Thank you.

 

[Rick Rothstein]

I am working in excel 2010 and I have a spreadsheet with many rows of long Text, in Column A. Within each text string at some point is date which is always in the format mm/dd/yyyy. I am trying to find a formula that I could put in each cell of column B that would capture this date in column B. Any help is greatly appreciated.

Does this do what you want...

=MID(A1,SEARCH("??/??/????",A1),10)

 

[jbesr1230]

Thank you Rick! This does exactly what I am looking for.