Hello Cherifa,
Assuming your text is in A6, the following two formulae will do it.
=DATEVALUE(MID(MID(MID(SUBSTITUTE(A6," ","^",1),1,256),FIND("^",SUBSTITUTE(A6," ","^",1)),256),2,FIND(" ",MID(MID(SUBSTITUTE(A6," ","^",1),1,256),FIND("^",SUBSTITUTE(A6," ","^",1)),256))-2)&"/"&MONTH(DATEVALUE(LEFT(A6,FIND(" ",A6)-1)&" 1"))&"/"&MID(SUBSTITUTE(A6," ","^",LEN(A6)-LEN(SUBSTITUTE(A6," ",""))),FIND("^",SUBSTITUTE(A6," ","^",LEN(A6)-LEN(SUBSTITUTE(A6," ",""))))+1,256))
=DATEVALUE(LEFT(RIGHT(A6,8),2)&"/"&MONTH(DATEVALUE(MID(MID(MID(SUBSTITUTE(A6," ","^",3),1,256),FIND("^",SUBSTITUTE(A6," ","^",3)),256),2,FIND(" ",MID(MID(SUBSTITUTE(A6," ","^",3),1,256),FIND("^",SUBSTITUTE(A6," ","^",3)),256))-2)&" 1"))&"/"&MID(SUBSTITUTE(A6," ","^",LEN(A6)-LEN(SUBSTITUTE(A6," ",""))),FIND("^",SUBSTITUTE(A6," ","^",LEN(A6)-LEN(SUBSTITUTE(A6," ",""))))+1,256))
You might have to switch the day and month extraction bits around depending on the set up of your computer date system and you will have to format the cells to get the date in your preferred format.
Regards
Harry