+ Reply to Thread
Results 1 to 3 of 3

Date and time as text sample column

  1. #1
    Forum Contributor
    Join Date
    03-06-2015
    Location
    houston, tx
    MS-Off Ver
    MS 365
    Posts
    490

    Date and time as text sample column

    See sample. Thank you

    need to have it in columns "need this" as result.
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Date and time as text sample column

    Please try

    =--REPLACE(MID(A5,5,7),3,,LEFT(A5,3))

    and
    =--RIGHT(A5,5)

    or
    =MOD(REPLACE(MID(A5:A7,5,20),3,,LEFT(A5:A7,3)),{99999,1})
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    03-06-2015
    Location
    houston, tx
    MS-Off Ver
    MS 365
    Posts
    490

    Re: Date and time as text sample column

    Thank you for your quick response.

+ 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. Replies: 1
    Last Post: 01-11-2022, 08:05 PM
  2. [SOLVED] Date not recognised in Date formatted column (sample file attached) Excel 2007
    By marco polo 2021 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-08-2021, 06:02 AM
  3. [SOLVED] Date and Time in column dont convert in Using Text to Columns
    By pick44 in forum Excel General
    Replies: 3
    Last Post: 02-07-2019, 03:56 PM
  4. [SOLVED] Sumproduct. count how many time a month appears (in column filled by date or text). #Value
    By adriendriver in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2013, 08:43 AM
  5. [SOLVED] Formatting a column to display the date and time instead of general text using VBA
    By bean29 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-13-2012, 08:46 AM
  6. Sort column with Date, Time and Text
    By dudedude in forum Excel General
    Replies: 2
    Last Post: 07-12-2010, 08:07 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