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: