Date Function
Luke,
Very exceptable unless there are no other numbers in the sentence e.g.
Product no. 1 dropped off on 11/01/2009 by Michelle Smith
"Luke M" wrote:
=DATEVALUE(MID(A2,FIND("/",A2)-2,10))
Format as date.
--
Best Regards,
Luke M
"Jen_T" wrote in message
...
If a cell has text and numeric (date) is there a way to pull the date out
easily ?
E.g.
Product dropped off on 11/01/2009 by Michelle Smith
I would like to see 11/01/2009
Thank you
.
|