Convert text to date format

		Microsoft Office Forums > Microsoft Excel > Excel
Convert text to date format

11-14-2015, 12:29 PM

klllmmm

Windows 10 Convert text to date format

Office 2016

Novice

Join Date: Nov 2015

Posts: 4

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")

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Non-printing button to convert a date field to text	Greengecko	Word VBA	1	09-09-2014 09:40 PM
How to convert a text file to an Excel file with the data format automatically?	mradmin	Excel	6	10-16-2013 10:34 AM
Text auto formatted as date format	Aikeedoh	Excel	5	09-06-2013 02:38 AM
Cannot Convert Text Cell to number format to be able to sort the data	jyfuller	Excel	10	06-19-2013 05:31 PM
How can I convert pptx to text format like Word, and later on create pptx too?	GetLost	PowerPoint	0	01-11-2012 04:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:51 PM.