If you want to apply a minor tweak to the document, it should not require much time to Concatenate date notification. Such a simple action does not have to demand extra education or running through manuals to understand it. Using the appropriate document modifying tool, you will not take more time than is necessary for such a quick edit. Use DocHub to simplify your modifying process regardless if you are an experienced user or if it’s the first time making use of an online editor service. This instrument will take minutes or so to learn to Concatenate date notification. The sole thing required to get more effective with editing is a DocHub account.
A simple document editor like DocHub can help you optimize the amount of time you need to devote to document modifying no matter your previous knowledge about this kind of resources. Create an account now and enhance your efficiency immediately with DocHub!
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
