You know you are using the right file editor when such a basic task as Consolidate age text does not take more time than it should. Modifying files is now a part of numerous working operations in various professional areas, which explains why convenience and straightforwardness are essential for editing instruments. If you find yourself studying guides or trying to find tips on how to Consolidate age text, you might want to get a more easy-to-use solution to save your time on theoretical learning. And here is where DocHub shines. No training is needed. Simply open the editor, which will guide you through its principal functions and features.
A workflow becomes smoother with DocHub. Make use of this instrument to complete the files you need in short time and take your productivity to the next level!
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