Concatenate cells  

Do you wish to join text of many cells to a single cell?
Simply do this:
1. Select the cells of a row that you desire to concatenate.
2. Click on the "Concatenate cells" button, in order to open the corresponding dialog box .
Automatically the text boxes will be activated in the dialog box, in order to enter the text that you want to add.
(if we don't enter any text, simply the content of the cells will be concatenated.
3. Press the Concatenate button. That is all.

This tool will make the concatenation in text or formula mode;
wherefore if the involved values change, the information will be updated.

See the following examples: