extract a date from a text string

Hi all. I have a sheet with a description that includes a date and time. I'd like to be able to pull the date out the string and populate a new column.
there is no consistent number of characters before the date, but all dates have the same format

the text strings look like this for example (I changed real names to fake ones... the rest of the data is as it is):

TMV for: Name IsHere 08/04/2016 10:15: Name to Westwave. Return to pick up and take home
TMV for: Another Person 08/04/2016 10:30: Another out for drive and coffee
TMV for: Someone Else 08/04/2016 11:00: Someone for shopping and return to John Doe Rd


any ideas???

thanks, Theo.

Try

Data in A1

=MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),MAX(IF(ISNUMBER(VALUE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))),ROW(INDIRECT("1:"&LEN(A1)))))-MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")-1))+0

Enter with Ctrl+Shift+Enter

Copy down

thanks John- sorry- I put a text string in A1 and place the formulae in B1. I get a #VALUE! error can you explain the 'Enter with Ctrl+Shift+Enter' that might be the issue..
such a fast reply- really appreciate it

Theo

thanks John- sorry- I put a text string in A1 and place the formulae in B1. I get a #VALUE! error can you explain the 'Enter with Ctrl+Shift+Enter' that might be the issue..
such a fast reply- really appreciate it

Theo

try

Formula:

Please Login or Register  to view this content.

with Control+Shift+Enter

data start in A1

If you want date as real date not as text, try

Formula:

Please Login or Register  to view this content.

(with Control+Shift+Enter) but cells should be formatted as DATE (short, long , whatever)

Try Sandy's formula - works fine.

CSE: Hold down Ctrl+Shift together then (hit!) Enter

or

=MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),10)+0

Just enter

Format cells as date