Concatenate cells in OpenOffice Calc to Connect to you, e.g., name
Open OpenOffice Calc and create your cells content. For example, you can enter in a cell a first name, in another cell, a surname. The complete name in a different cell, you should concatenate the cells. Do the following:
- Click in the cell in which the linked content to appear.
- In the formula field enter "=CONCATENATE(Cell1;" ";Cell2)" on.
- Instead of "Cell1" and "Cell2", enter the cell name, e.g., A3 or B8. Note the spaces between the cells name.
OpenOffice Calc: cells concatenate
Read also, how the color of the Page in OpenOffice change.
