Results 1 to 19 of 19

How do I split the date & time into two separate columns?

Threaded View

  1. #9
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: How do I split the date & time into two separate columns?

    Nanner is a diminutive for Banana - The
    Sub SplitLongData(): Dim D
    is the name of the sub and declaration of a variant for the little array And, thanks for the rep!

    BTW - using Colons the whole routine could be written on one line:

    Sub SplitLongDate(): Dim D:D = Range("A1"):Range("B1:C1") = Split(D, " "):End Sub
    Last edited by xladept; 08-20-2014 at 04:54 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 07-03-2012, 05:49 PM
  2. Split date into 3 separate columns
    By paulr24 in forum Excel General
    Replies: 4
    Last Post: 01-25-2012, 01:51 PM
  3. Merging separate date and time columns into one
    By Gadgets in forum Excel General
    Replies: 5
    Last Post: 07-26-2006, 04:24 PM
  4. [SOLVED] Split a date/time column into 2 columns
    By RKMiller in forum Excel General
    Replies: 1
    Last Post: 12-19-2005, 12:10 PM
  5. Replies: 0
    Last Post: 08-23-2005, 12:23 PM

Tags for this Thread

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