Document editing comes as a part of many occupations and careers, which is the reason instruments for it should be reachable and unambiguous in their use. A sophisticated online editor can spare you plenty of headaches and save a considerable amount of time if you have to Combine text deed.
DocHub is an excellent illustration of a tool you can grasp very quickly with all the valuable features accessible. You can start modifying instantly after creating an account. The user-friendly interface of the editor will allow you to locate and employ any function in no time. Experience the difference using the DocHub editor the moment you open it to Combine text deed.
Being an integral part of workflows, file editing should stay easy. Utilizing DocHub, you can quickly find your way around the editor making the desired changes to your document without a minute lost.
To concatenate a date with text in a cell, use the text function. In the example worksheet, there is a table with lists of old employees of a company. Column G should have a comment with details of when employee joined and left the company. Use the ampersand symbol to concatenate data in different cells. In cell G7, type =C7&" joined on "&E7&" left the company on "&F7 to display the actual date using the text function before the dates. Excel converts dates to serial numbers, so use the text function to display the actual date.