When you edit files in various formats daily, the universality of your document tools matters a lot. If your instruments work with only some of the popular formats, you might find yourself switching between application windows to join date in text and manage other file formats. If you wish to remove the headache of document editing, get a platform that will easily handle any format.
With DocHub, you do not need to focus on anything apart from actual document editing. You won’t have to juggle programs to work with different formats. It can help you modify your text as easily as any other format. Create text documents, modify, and share them in one online editing platform that saves you time and boosts your productivity. All you need to do is register a free account at DocHub, which takes only a few minutes.
You won’t have to become an editing multitasker with DocHub. Its functionality is sufficient for speedy document editing, regardless of the format you want to revise. Begin with creating a free account to see how effortless document management might be with a tool designed particularly to meet your needs.
if you need to concatenate a date with text in a Cell you need to use the text function the example worksheet has a table with lists of old employees of a company with the details of when the employee joined the company and when the employee left the company if column G should have a comment with the details of when employee joined and left the company you can concatenate data in different cells using the ampersand symbol click on cell g7 in the formula bar type equal to the cell c7 which contains the employee name ampersand within double quotes type the text joined on ampersand the joining date which is in cell e7 so type II 7 then ampersand again within double quotes type the text left the company on ampersand cell number f7 which contains the date when the employee left the company hit enter you can see the dates are converted to serial numbers by Excel if you want to display the actual date you need to change the formula to have text function before the dates type text before the