+ Reply to Thread
Results 1 to 6 of 6

Reading date from a cell with series of dates

  1. 04-13-2010, 02:13 AM #1
    bruce71101
    bruce71101 is offline
    Registered User
    Join Date
    04-13-2010
    Location
    Taiwan
    MS-Off Ver
    Excel 2007
    Posts
    25

    Reading date from a cell with series of dates

    Hello,

    I have a cell with series of dates separated by commas. For example like this

    01/01/2010, 01/02/2010, 01/03/2010, 01/04/2010

    is there a way to read each date and save them into different cells like this

    01/01/2010
    01/02/2010
    01/03/2010
    01/04/2010


    thanks.
    Last edited by bruce71101; 04-13-2010 at 03:56 AM.
    Reply With QuoteRegister To Reply
  2. 04-13-2010, 02:33 AM #2
    vshankaa
    vshankaa is offline
    Registered User
    Join Date
    04-09-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Reading date from a cell with series of dates

    Check this out...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 04-13-2010, 02:56 AM #3
    bruce71101
    bruce71101 is offline
    Registered User
    Join Date
    04-13-2010
    Location
    Taiwan
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Reading date from a cell with series of dates

    Thanks for the quick response, vshankaa

    one more question though, how do i make it split at the cell i am selecting instead of cell(1,1)

    thanks
    Reply With QuoteRegister To Reply
  4. 04-13-2010, 03:10 AM #4
    vshankaa
    vshankaa is offline
    Registered User
    Join Date
    04-09-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Reading date from a cell with series of dates

    Are you talking abou the source cell where you have the dates or the destination cells where they want to be split?
    Reply With QuoteRegister To Reply
  5. 04-13-2010, 03:24 AM #5
    bruce71101
    bruce71101 is offline
    Registered User
    Join Date
    04-13-2010
    Location
    Taiwan
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Reading date from a cell with series of dates

    Quote Originally Posted by vshankaa View Post
    Are you talking abou the source cell where you have the dates or the destination cells where they want to be split?
    the source cell
    Reply With QuoteRegister To Reply
  6. 04-13-2010, 03:40 AM #6
    vshankaa
    vshankaa is offline
    Registered User
    Join Date
    04-09-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Reading date from a cell with series of dates

    Once you open the example workbook which I have attached in the previous post, press Alt+F11, you'll get the VB Editor. There double click on Sheet 1, and you'll see my code in it. You can change the source cell in it...

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1