Results 1 to 6 of 6

Extracting DATES partial or full from text

Threaded View

  1. #1
    Registered User
    Join Date
    07-09-2020
    Location
    Leeds, England
    MS-Off Ver
    Microsoft Excel 2021 MSO (Version 2210 Build 16.0.15726.20188) 64-bit
    Posts
    15

    Extracting DATES partial or full from text

    Hello,

    Had a look around to solve this one but all formulas I've tried don't seem to work for my data.

    Just need to remove the date part of the text in col A, and really just need the date range extracting (I can split the dates once out of the main text) As its just a Month and Year in most cases, some only have a start date (vehicle still in production) some have a start and end date.

    Help please!!

    Thank you
    Matt
    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. Replies: 2
    Last Post: 03-20-2020, 07:17 PM
  2. [SOLVED] Typing partial text to result in full text in data validation drop down box
    By jennis7242 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-18-2018, 09:39 PM
  3. Wildcard in Excel is selecting full string instead of partial text.
    By Jriggerz in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-24-2017, 06:11 AM
  4. Search and Match partial text string to full text and return a value
    By homa5424 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-09-2017, 10:52 AM
  5. [SOLVED] Counif in vertical list for 2 creterias looking for partial and full text inside cell
    By Sekars in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 07-31-2017, 02:23 PM
  6. [SOLVED] conversion of full and partial date into full format
    By sarat47 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2014, 03:43 PM
  7. VLOOKUP a full text in a partial data field
    By lukeareed in forum Excel General
    Replies: 3
    Last Post: 03-28-2014, 11:13 AM

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