Date Function
Brilliant Biff
"T. Valko" wrote:
Try this...
=LOOKUP(1E100,--MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"01234567 89")),ROW(INDIRECT("1:"&LEN(A2)))))
Format as Date
--
Biff
Microsoft Excel MVP
"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
.
|