Text to Columns Wizard<\/a> which has three steps.<\/p>\n\n\n\nIn the first step, we will choose Delimited<\/strong> as the type that best describes our data:<\/p>\n\n\n\n <\/figure>\n\n\n\nThen we will click Next<\/strong> and go to Step 2<\/strong>. Since the data in our cell is separated by space, we will select Space<\/strong> as our Delimiter<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nIn the final step, we have to exclude the time and AM from our final data. We will click on the second and third parts of our text and choose the Do not import column (skip<\/strong>). This will make sure that we only keep our date in the A column<\/strong>, but not the time.<\/p>\n\n\n\n <\/figure>\n\n\n\nWe will, however, be shown the time in the cells in the A column. We will see a generic (12 AM) time due to the format of the cells.<\/p>\n\n\n\n <\/figure>\n\n\n\nAll we have to do to fix this is to change the format of the cells in the A column<\/strong> to either Short <\/strong>or Long Date<\/strong>.<\/p>\n\n\n\nRemove the Time with Find and Replace<\/h2>\n\n\n\n We can always call Find and Replace<\/strong> to help us remove the time from time and date.<\/p>\n\n\n\nIn our E column<\/strong>, we have our original values. We will select range E2:E4<\/strong>, go to Home<\/strong> >> Editing <\/strong>>> Find & Select<\/strong> >> Replace<\/strong>.<\/p>\n\n\n\nWe will be presented with Find and Replace<\/strong> window in which we will input space and asterisk sign (*<\/strong>).<\/p>\n\n\n\n <\/figure>\n\n\n\nThis will make sure that all the text after the space in our cells gets deleted. Since this text is the time in our cells, this will leave us only with the dates once we click Replace All<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nOnce again, we will be shown the time in our data. We will see a generic (12 AM) time due to the format of the cells.<\/p>\n\n\n\n
As in the examples above, we format the cells in the E column<\/strong> to be either Short<\/strong> or Long <\/strong>dates.<\/p>\n","protected":false},"excerpt":{"rendered":"When using Excel, we will often find ourselves in a situation where we have to manipulate data. More often than not, these data…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Remove Time from Date and Time in Excel<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n