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...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 DatesCovert date format in ms excel 2013 from MM-DD-YYYY to DD-MM-YYYY 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
