SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: Excell question

  1. #1
    there is no box baztorres's Avatar
    Join Date
    May 2004
    Location
    UK - London \ Surrey
    Posts
    372
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Excell question

    Hi guys,

    Would anyone know how to split a column in Excell that contains both Time and Date into two seperate columns??

    Cheers,

    Baz
    Baz
    ---

  2. #2
    SitePoint Wizard silver trophy rushiku's Avatar
    Join Date
    Dec 2003
    Location
    A van down by the river
    Posts
    2,056
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)
    select the data to be split, goto data > text to columns, select the delimiter, click okay

  3. #3
    SitePoint Zealot
    Join Date
    Jun 2002
    Location
    Wiltshire, England
    Posts
    106
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    nice tip there rushiku i thought i was pretty clued up on excel but never came across that tool before, very handy

  4. #4
    there is no box baztorres's Avatar
    Join Date
    May 2004
    Location
    UK - London \ Surrey
    Posts
    372
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Bloody genius.
    Luv ya rushiku
    You have saved me so much work it is unbelievable!!!!

    Cheers
    Baz
    ---


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
  •