Results 1 to 4 of 4

Extracting Date/Time from 1 cell

Threaded View

  1. #1
    Registered User
    Join Date
    05-11-2009
    Location
    Belfast
    MS-Off Ver
    Excel 2019
    Posts
    66

    Extracting Date/Time from 1 cell

    I have a column of cells that look like:
    20090715130836


    Which are I am assuming broken into
    YYYY MM DD HH MM SS

    Can anyone tell me how to extract the information from this on cell into Yr Mnth Day Time

    Thanks in advance
    Last edited by jaywizz; 08-19-2010 at 10:09 AM.

Thread Information

Users Browsing this Thread

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

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