Removing time element of Long Date Format using Excel Posted on February 1, 2016 in Excel =TEXT(IF(CELL("type",A1)="l",LEFT(A1,FIND(" ",A1)),INT(A1)),"mm/dd/yyyy") You might also like...The ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine. (System.Data)Right side of a particular keyword in a string/text on ExcelFind a word between a string (sentence) using ExcelExcel Tutorial – Removing Stamp Time from Dates Previous Post: Covert date format in ms excel 2013 from MM-DD-YYYY to DD-MM-YYYY Next Post: How to rename SQL Server after server cloning? Add Comment Cancel replyName (required) Email (required) Website (optional) Submit Comment