"macropod" wrote:

Hi Terry,

For a 'date' in A1, try:
=DATEVALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBST ITUTE(MID(A1,FIND(" ",A1)+1,LEN(A1)),"st",""),"nd",""),"rd",""),"th"," "))
and format the result as a date.

Cheers

Thanks both, I'll try those suggestions.

--
Terry, East Grinstead, UK