+ Reply to Thread
Results 1 to 5 of 5

Extract string based on numerical value (Date)

  1. #1
    Forum Contributor
    Join Date
    03-12-2014
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    118

    Extract string based on numerical value (Date)

    I have Data in Column "B"
    Extract the string in column "B" based
    Wants to separate/extract the string from the date and time starts (e.g. “08-03-2014 08:43:39 PM:” OR “14-09-2014 08:20:27 AM:” OR “24-11-2014 07:41:28 PM:” etc.) and end the break before the start of next date and time. please refer example. Separated data starts from column C
    (Data from the data and time to before the next data and time)
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-05-2012
    Location
    Dubai
    MS-Off Ver
    Office 365
    Posts
    409

    Re: Extract string based on numerical value (Date)

    Since the Length is always same for the Date and Time which is 24 always
    you can use Mid function to extract the string from it... to test add a blank column next to B
    and use this.... =MID(B2,24,LEN(B2)-24)

  3. #3
    Forum Contributor
    Join Date
    03-12-2014
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    118

    Re: Extract string based on numerical value (Date)

    IT IS EXTRACTING ONLY FIRST PART. It is not extracting the message after the next date in same string. please check the data in cell b1

  4. #4
    Forum Contributor
    Join Date
    09-05-2012
    Location
    Dubai
    MS-Off Ver
    Office 365
    Posts
    409

    Re: Extract string based on numerical value (Date)

    It is Complex...
    I tried below... Take a sample value from cell b1 and paste to test in another sheet...
    just to add a delimiter i replaced AM: with $ , also PM: with $ , then in cell C1 , = clean(b1).. copy and paste spl values..

    then do the text to columns method to separate the values

  5. #5
    Forum Contributor
    Join Date
    03-12-2014
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    118

    Re: Extract string based on numerical value (Date)

    You are right....

    But I want to separate the string with date and time

+ 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. Extract string based on specific string
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-15-2014, 12:16 AM
  2. [SOLVED] Extract a date from a string
    By DavidNO in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 12-19-2013, 05:55 PM
  3. How to generate a string of text, based on numerical values defined in sheet
    By fleshbug in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2013, 06:04 PM
  4. Convert string dates to proper numerical date format
    By Codpops in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-21-2008, 01:01 PM
  5. extract date from string
    By kdp145 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2006, 10:54 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