Results 1 to 5 of 5

Extract string based on numerical value (Date)

Threaded View

winmaxservices1 Extract string based on... 01-27-2015, 02:44 AM
naveenmarapaka Re: Extract string based on... 01-27-2015, 03:26 AM
winmaxservices1 Re: Extract string based on... 01-27-2015, 03:41 AM
naveenmarapaka Re: Extract string based on... 01-27-2015, 03:57 AM
winmaxservices1 Re: Extract string based on... 01-27-2015, 04:07 AM
  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

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