Hello

I am trying to extract dates from cells which have variable text length and sometimes have more than one space. I have tried using the following code:

=RIGHT(B4,LEN(B4)-FIND(" ",B4))

which works fine on the following examples (though it would be nice to get same date format dd/mm/yyyy)

BLPD10125 27/09/2013
BLPD11935 18/07/11

but doesn't work on following

CON/ 2009-20-24 / 30-09-12
because it's recognising that there are two spaces therefore giving following answer:
2009-20-24 / 30-09-12

Hope someone can help

Thanks