Date Function
in [Functions]
|
Prev: how do i find out what data is hidden i excel
Next: Adding and then sorting data into an already existing Excel 2007 w
From: Jen_T on 26 Mar 2010 14:35 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
From: T. Valko on 26 Mar 2010 14:50 Try this... =LOOKUP(1E100,--MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),ROW(INDIRECT("1:"&LEN(A2))))) Format as Date -- Biff Microsoft Excel MVP "Jen_T" <JenT(a)discussions.microsoft.com> wrote in message news:24E6D3D1-892D-4A59-8BD4-BFA191F63ED4(a)microsoft.com... > 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
From: Luke M on 26 Mar 2010 14:53 =DATEVALUE(MID(A2,FIND("/",A2)-2,10)) Format as date. -- Best Regards, Luke M "Jen_T" <JenT(a)discussions.microsoft.com> wrote in message news:24E6D3D1-892D-4A59-8BD4-BFA191F63ED4(a)microsoft.com... > 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
From: Ron on 26 Mar 2010 15:27 Here's some possible leads: http://office.microsoft.com/en-us/excel/HA011549011033.aspx http://www.meadinkent.co.uk/xlextracttext.htm "Jen_T" wrote: > 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
From: Ron on 26 Mar 2010 15:31
Brilliant Biff "T. Valko" wrote: > Try this... > > =LOOKUP(1E100,--MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),ROW(INDIRECT("1:"&LEN(A2))))) > > Format as Date > > -- > Biff > Microsoft Excel MVP > > > "Jen_T" <JenT(a)discussions.microsoft.com> wrote in message > news:24E6D3D1-892D-4A59-8BD4-BFA191F63ED4(a)microsoft.com... > > 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 > > > . > |