Microsoft Office Forums - View Single Post - [Solved] Convert text to date format

Thread: [Solved] Convert text to date format

View Single Post

Old

11-14-2015, 12:29 PM

klllmmm

klllmmm is offline

klllmmm uses Windows 10

Windows 10 klllmmm uses Office 2016

klllmmm uses Office 2016

Office 2016

Novice

The original poster

Join Date: Nov 2015

Posts: 4

klllmmm is on a distinguished road

Default

Found it from anther forum

=TEXT(MID(A1,FIND(" ",A1)+1,FIND(",",A1)-FIND(" ",A1)-1)&" "&LEFT(A1,FIND(" ",A1)-1)&" "&RIGHT(A1,4),"dd/mm/yy")

Reply With Quote