+ Reply to Thread
Results 1 to 3 of 3

Extracting Date from cell

  1. #1
    Registered User
    Join Date
    07-07-2014
    Location
    UAE
    MS-Off Ver
    2010
    Posts
    2

    Extracting Date from cell

    iF I have an excel cell VALUE OF:
    2014-07-07T12:01:58;2014-07-07T14:01:58

    I want to extract the dates from this cell and put the value on 2 separate cells.

    A1: 2014-07-07 12:01:58
    B1: 2014-07-07 14:01:58

    Appreciate your help....Thanks

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,080

    Re: Extracting Date from cell

    Two Helper columns perhaps?

    =SUBSTITUTE(LEFT(A1,19),"T"," ")+0
    and
    =SUBSTITUTE(RIGHT(A1,19),"T"," ")+0

    Otherwise a VBA approach
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    07-07-2014
    Location
    UAE
    MS-Off Ver
    2010
    Posts
    2

    Re: Extracting Date from cell

    Thanks a lot...

+ 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] Need help extracting date from cell
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2013, 08:34 PM
  2. Extracting date from cell
    By Zack99 in forum Excel General
    Replies: 8
    Last Post: 12-13-2012, 11:29 AM
  3. Extracting date from cell
    By rhudgins in forum Excel General
    Replies: 2
    Last Post: 10-14-2011, 04:24 PM
  4. extracting date from cell that has two spaces
    By DavidBW in forum Excel General
    Replies: 2
    Last Post: 09-22-2011, 08:44 AM
  5. Extracting Date/Time from 1 cell
    By jaywizz in forum Excel General
    Replies: 3
    Last Post: 08-19-2010, 09:51 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