Unusual file formats in your day-to-day papers management and editing operations can create instant confusion over how to edit them. You may need more than pre-installed computer software for efficient and quick file editing. If you need to join date in excel or make any other basic alternation in your file, choose a document editor that has the features for you to deal with ease. To handle all of the formats, such as excel, choosing an editor that works properly with all types of documents is your best choice.
Try DocHub for efficient file management, regardless of your document’s format. It has potent online editing tools that simplify your papers management process. You can easily create, edit, annotate, and share any document, as all you need to access these features is an internet connection and an active DocHub account. A single document tool is everything required. Do not waste time jumping between various programs for different documents.
Enjoy the efficiency of working with a tool created specifically to simplify papers processing. See how effortless it is to edit any file, even if it is the very first time you have worked with its format. Register an account now and enhance your whole working process.
hi in this video Im going to show you how to take data thats a date and thats separated into separate columns such as the month day and year and combine it all into one column so it makes it a little bit more easy to use and view so its basically a pretty easy type of function the function used to combine the month day and year all into one cell is the date function and its actually pretty easy to use so I can do is go into this column type of date and select the date function and its gonna take three arguments the Year month and day so Im gonna select the year here comma months comma and day and just press ENTER and youll see that it has showed up now we see that the the value is kind of nicely formatted here and Excel is smart enough to figure out that this is a date but sometimes when Excel uses day formula you get this general no specific date formula and this is basically the serial number format which Excel sees dates and the way it displays States is what I showed you e