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

Hello,

Yes, Sorry.

So, Col A is how the data is sent to me.

I need to get the date part out of that Col A and into Col D as the complete date range.

(Col B and Col C are just the split information from Col D.)

Thank you.
Matt

Try this in D2 and copied down.

Please Login or Register  to view this content.

Fantastic! Thank you very much. Exactly what I needed!

Thank you
Matt

You are welcome.
--------------------------------------
If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.