Unusual file formats in your daily document management and editing operations can create instant confusion over how to edit them. You might need more than pre-installed computer software for effective and speedy document editing. If you need to erase date in csv or make any other basic change in your document, choose a document editor that has the features for you to work with ease. To handle all of the formats, such as csv, choosing an editor that works properly with all kinds of documents is your best choice.
Try DocHub for efficient document management, irrespective of your document’s format. It offers powerful online editing instruments that simplify your document management process. It is easy to create, edit, annotate, and share any file, as all you need to access these characteristics is an internet connection and an active DocHub profile. Just one document solution is everything required. Do not lose time jumping between different programs for different documents.
Enjoy the efficiency of working with an instrument created specifically to simplify document processing. See how straightforward it really is to revise any document, even when it is the very first time you have dealt with its format. Sign up a free account now and improve your whole working process.
hey guys eddie the magic monk here as you can see i have a csv file called test data open in excel and in this file you can see that the dates are in the american format okay so here in australia we write dates as 2507 if its 25th of july but in america its 7 25 so i want to change this to match the australian or the international standard so this is what i would do okay i would get out of this csv file im going to create another one uh an excel file and im gonna call it date converted okay and im gonna open up this excel file and what im gonna do is im gonna go into the data menu and im going to click on from text csv and its in the section called get and transform data and what it does is it obtains the data from a csv file and transforms it before we put it in the spreadsheet so lets click on that and lets choose the folder from our desktop test data and you can see its uh detected the data and here the first column are the dates and forget the second column thats just