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.

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






Leave a Reply

You must be logged in to post a comment.

Testimonials


“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




“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




“The course was really thorough and Steve was very knowledgeable and explained things very well. I’ve not used Microsoft Project before but now I feel very confident that I’ll be able to use it for what I need to do in my job”.

Craig Forster
Estimator, John F Hunt Regeneration Ltd




“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