Extract Date as Text

[How_Do_I]

How would I extract June 1918 from the following as text please?

Excel Workbook
	A
8	June 1918 Moved to Dublin.
Sheet1

 

[How_Do_I]

As an alternative to your new formulas from Posts # 5 and # 6:

Thanks for that Tetra, I ran it down 100 rows of data to check and it is working,

 

[Peter_SSs]

Looking at your sample data, I'm wondering if this would also work for you?

=IF(MID(G12,4,1)=" ",LEFT(G12,8),TEXT(SUBSTITUTE(LEFT(G12,10),".","-"),"dd-mmm-yyyy"))

 

[How_Do_I]

Yes Ford, some will be September 1917 (I entered that in full to stop it reverting to 01-Sep-17) and other dates will be the actual date, the first of September 1917 (01-Sep-17)

 

[How_Do_I]

Looking at your sample data, I'm wondering if this would also work for you?

=IF(MID(G12,4,1)=" ",LEFT(G12,8),TEXT(SUBSTITUTE(LEFT(G12,10),".","-"),"dd-mmm-yyyy"))

I ran that down 100 sample rows of data and that is working too thank you Peter.