Main Page Sitemap

Most viewed

LepideAuditor for SharePoint 14.05.01 license number plus patch
netDrive 2.5.7 Crack Patch Wir verwenden Cookies, um netDrive 2.5.7 Crack Patch ein verbessertes Online-Erlebnis zu bieten und netDrive 2.5.7 Crack Patch Ihnen speziell auf Sie zugeshnittene Inhalte und Dienstleistungen bereitzustellen. Mit der Nutzung von Dailymotion geben Sie uns Ihr Einverständnis für den Einsatz...
Read more
GTimer Deluxe 1.1.3 Activator free crack incl
Magical Jelly Bean License Key Finder This article has been contributed by Richard Thompson, founder member of Central Technology, a Microsoft Gold Certified Partner who frequently manage SAM reviews for customers. We all know that Microsoft ‘SAM Review’ can be translated to licensing audit...
Read more
Reason 4.0.1 Serial key with patch
Invoice quot;tions and Purchase Orders Maker Lite - FreeInvoicing Software Invoice Software - with Multiple Invoice Templates Create invoice quotations purchase orders using this software. With its powerful interface which provides many attractive features and yet very flexible to integrate into your own business operations...
Read more

Remove Time and Date Stamps From Multiple


VBIndent 6.8 lifetime license included


Sometimes, when you import data into Excel, if there has a column of date with time stamp, such as 2012/6/27 12:23, and you don’t want to retain the time stamp and want to remove the time (12:23) from the date. How could you quickly remove time from date in mulitple cells in Excel?

Remove time from date with Find and Replace function

Remove time from date with Text to Columns function

Remove time from date with VBA code

Remove time from date with Kutools for Excel

Convert to Date

In some times, you can have multiple nonstandard dates in your worksheet, and to convert all of them to the standard date mm/dd/yyyy maybe troublesome for you. Here Kutools for Excel's Conver to Date can quickly convert dates to standard date as mm/dd/yyyy format.

Go to Download
Free Trial 60 daysPurchase
PayPal / MyCommerce

doc convert date
Hot
excel-tab-banner-2014-12-02
Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

How to be more efficient and save time when using Excel?

arrow blue right bubbleRemove time from date with Find and Replace function

1. Select the date range that you want to remove the time.

2. Click Home > Find & Select > Replace, and a Find and Replace dialog box will pop out. See screeenshot:

doc remove time from date1

3. Then enter a spacebar and a asterisk into the Find what box. And leave blank in the Replace with box.

4. Click Replace All. And all of the time stamp have been removed in the date range. See screenshot:

doc-remove-time-from-date2

5. Then you can format the range to show only the date.

arrow blue right bubbleRemove time from date with Text to Columns function

With the function of Text to Columns, you can also remove time from the date. Please do as the following steps:

Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.

Go to Download
Free Trial 60 daysPurchase
PayPal / MyCommerce

1. Highlight the range you need to delete the time stamps.

2. Click Data > Text to Columns, and a Convert Text to Columns Wizard will appear. See screenshot
:doc-remove-time-from-date3

3. Check Delimited, and click Next. Then check Space, and go on next.
doc-remove-time-from-date4

4. At last, click Finish. And the time have been isolated from the date. See screenshot:
doc-remove-time-from-date5

5. Then you can delete column D. And remember to format the date as you like.

arrow blue right bubbleRemove time from date with VBA code

The following VBA code can help you quickly to remove the time stamps from the date directly. Do as follows:

Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.

Go to Download
Free Trial 60 daysPurchase
PayPal / MyCommerce

1. Select the range that you want to remove the time.

2. Click Developer>Visual Basic or press Alt + F11, a new Microsoft Visual Basic for applications window will be displayed, click Insert>Module, and input the following code into the Module:

VBA: Remove time from date.

Sub ConvertDates() 'Updateby20140529 Dim Rng As Range Dim WorkRng As Range On Error Resume Next xTitleId = "KutoolsforExcel" Set WorkRng = Application.Selection Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8) For Each Rng In WorkRng Rng.Value = VBA.Int(Rng.Value) Next WorkRng.NumberFormat = "mm/dd/yyyy" End Sub

3. Then click doc-multiply-calculation-3 button to run the code. And a dialog pops out for selecting a range to remove the time from date. See screenshot:
doc-remove-time-from-date7

4. Click OK, and Aall of the time in selection have been deleted and the date format also have been set.
doc-remove-time-from-date6

arrow blue right bubbleRemove time from date with Kutools for Excel

Addition to above method, if you have installed Kutools for Excel, you can use the Extract Text utility to extract date only from data and time string.

Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.

Go to Download
Free Trial 60 daysPurchase
PayPal / MyCommerce

After free installing Kutools for Excel, please do as below:

1. Select the data range you want to remove the time, and click Kutools > Text > Extract Text. See screenshot:
doc kutools 1

2. In the Extract Text dialog, type and a space into the Text box, and click Add to add the extracting criterion to the Extract list. See screenshots:

doc remove time from date 2doc remove time from date 3

3. Click Ok, and select a cell to put out the dialog. See screenshot:
doc remove time from date 4

4. Click OK. Then right click at the extracting result and click Format Cells from the menu, and in the Format Cells dialog, click Date and select a type you need. See screenshots:

doc remove time from date 5doc remove time from date 6

5. Click OK. Now the times have been remove and only dates are extracted.

doc remove time from date 7
Click here you can get more details about Extract Text.

You maybe interested in this:

good ideaConvert Time

Kutools' Convert Time utility can quickly convert a time to decimal hours, minutes, seconds.

Go to Download
Free Trial 60 daysPurchase
PayPal / MyCommerce

doc convert time 1

Time to decimal hours

Time to decimal minutes

Time to decimal seconds

pay attention1If you are interested in this addi-in, download the 60-days free trial.

Related Articals:

How to remove year from date in Excel?

How to change multiple dates to day of week in excel?

Convert date to weekday name or month name in Excel?

How to change American date format in Excel 2007/2010?

Is your problem solved?

Yes, I want to be more efficiency and save time when using Excel          No, the problem persists and I need further support

Recommended Productivity Tools

The following tools will greatly save your time and effort, which one do you prefer?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: 120 powerful new functions for Excel, Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 More than 120 powerful advanced functions which designed for Excel:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

btn read more     btn download     btn purchase


How to remove time from date in Excel? - m BulkFileChanger: Change date/time/attributes of multiple files - NirSoft Remove date stamp from your photographs - the fast and easy way


918
Sitemap