excel - Converting Timestamp Text to Date Format using VBA -

excel - Converting Timestamp Text to Date Format using VBA -

i have next type of timestamp in csv file several one thousand lines:

oct 1, 2014 - 06:22:25

now know can extract info using formulas, , theoretically in vba well. however, seems rather messy solution write out worksheetapplication functions.

is there standard function allow me this? hoping can shine lite on me?

if have understood question properly, dont need vba. can using formula... have converted string date format.

a1 = oct 1, 2014 - 06:22:25 b1 = =text(datevalue(mid(a1,1,find("-",a1)-2)),"dd/mm/yy")

hope helps

excel excel-vba