 |
01670 732139 |
 |
steve@itseasy.co.uk |
Link cells together
Join cells together in Libreoffice Calc
There are two main ways to link cells together in Calc, using the Concatenate function or using the & symbol. Both methods will pull data from separate cells and join them together. If you require spaces between the cell information, add open quotes and then a space, followed by close quotes.
The & Symbol to join cells
To use the & symbol, start your formula in the same way as always, with the equals sign, then select your first cell. After the first cell type the & symbol and the open quotes to create a space then close quotes. This space will appear between the data in linked cells. Now type another & symbol and click on the second cell. If you have more cells to join repeat the process, then finally click the tick.
Concatenation to link cells
To use the concatenation function to link cells, select the function wizard. Once the wizard opens, type concatenate to find the correct function. When the function wizard displays the boxes to select cells, start the process by selecting your first cell. In the second box displayed, add the open and closed quotes. (This gives you the space). Next select the second cell and so on. Once all the cells and spaces are created click OK.
Text to Columns
If you have data in one single cell that should appear in multiple cells, you can use the Text to Column feature. The text to columns feature is on the Data Tab of the Ribbon. Once activated the wizard steps through the process. How your data are displayed, will depend on which options to select. When you have finished, click OK and the cells will spill over into the cells as selected.
Check out courses here
Online training courses here
Check out other video on my YouTube channel here
Testimonials
“I studied with Steve when we completed our CiPD CTP together. During the course I found Steve to be very personable and also very professional. Steve was first on my list of suppliers. Steve was very competitively priced and very accommodating.”
Simon Snowdon
European Training Manager at HP Enterprise Services
“Steve’s background in IT training clearly provided him with great organisational and managerial skills which he put to good use at Second Chance Enterprises. His ability to see the long term strategy as well as manage the day to day management is one of his biggest strengths.”
Chriss Graham
Project Coordinator at Daisy Group
Craig Forster
Estimator, John F Hunt Regeneration Ltd
“Steve delivered a number of Microsoft Office Training Sessions to a range of employees across Newcastle College. The service provided by Steve is second to none. I have no hesitations in recommending him to other employers.”
Christine Jackman
Learning Manager(North) - Winner of Training Programme of the Year NECCA
