+ Reply to Thread
Results 1 to 4 of 4

Extracting a date from text in a cell

  1. #1
    Registered User
    Join Date
    05-06-2014
    Location
    Morrisville, NC
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    43

    Extracting a date from text in a cell

    Considering this is in L2, what would I use to pull the 01-21-15 from here in a dynamic method, as the 1.381 can be 0-4 decimals long?

    L2's Text
    0,"xxxxxxxx","0","0","0","0","0","0","0","0","0","0",0,"0",1.381,"01-21-15","08:42",0","0","0","0","0",*

    Thanks!!!

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,638

    Re: Extracting a date from text in a cell

    =MID(L2,SEARCH("??-??-??",L2),8)
    try this
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    05-06-2014
    Location
    Morrisville, NC
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    43

    Re: Extracting a date from text in a cell

    Perfect, Thanks!!

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,638

    Re: Extracting a date from text in a cell

    you are welcome

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Extracting the date from a text string and then UN-reversing it...
    By TommyK25 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-31-2014, 11:59 AM
  2. Excel 2013 – need help extracting date and time from text cell plus more.
    By Art Mann in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-18-2014, 10:55 AM
  3. Extracting last date in text string
    By mmaya4 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-19-2014, 01:45 PM
  4. [SOLVED] Extracting numbers from text and converting into a date
    By ciapul12 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-15-2014, 07:01 PM
  5. Extracting a Date from a text string
    By andrewc in forum Excel General
    Replies: 6
    Last Post: 09-22-2009, 06:44 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1