How can I convert odd date format to date type?

[Certified]

Hi,

I have a schedule with a the following date format -

19-Jul3 is equal to Jul 19th 2019

19-jul2 is equal to Jul 19th 2019

19-jul is equal to Jul 19th 2019

There schedule starts at 2019.

How can I convert this to an actual date type? The numbers at the end are giving problems..

 

[Crystalyzer]

Is this just text in a cell? Can you post the data with the XL2BB tool?

 

[Certified]

Is this just text in a cell? Can you post the data with the XL2BB tool?

It looks like an add-in. I can't download anything at my work.

But yes, it is just a text in a cell.

 

[Crystalyzer]

Book2
	A	B
1
2	19-Jul3	7/19/2019
3	19-Jul2	7/19/2019
4	19-Jul	7/19/2019
Sheet1

Cell Formulas
Range	Formula
B2:B4	B2	=DATEVALUE(LEFT(A2,FIND("-",A2,1)-1)&"/"&MID(A2,FIND("-",A2,1)+1,3)& "/" & "2019")

 

[Alex Blakenburg]

If you are intending to use Power Query, there are lots of ways of doing it. The below is just using the interface (no manual M Code).
Hard coding 2019 concerns me a bit though, how will you know when it refers to a different year ?