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
Bookmarks