Type CONCATENATE in that cell or in the formula bar. Easily add words from different cells together with Kutools for Excel. To do this click inside the last cell in the fourth column click on Layout in the ribbon and then click on Formula at the far right.
Select the cell formulas you want to add to and click Kutools More Convert Refers.
If you do read on for a simple but often missed tip for adding them quickly. Here is how this formula works. It includes the text characters as well as the space characters. To do this click inside the last cell in the fourth column click on Layout in the ribbon and then click on Formula at the far right.