We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How merge cell content in Libre Calc? [closed]

asked 2013-05-13 07:54:49 +0200

Xe2546 gravatar image

updated 2013-10-08 22:21:58 +0200

manj_k gravatar image

For example, I have cell content in columns A, B, & C and I wanted a few or all of the rows cell content merged into column A. How can I do it?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-31 16:27:06.695948

2 Answers

Sort by » oldest newest most voted

answered 2013-05-13 11:49:53 +0200

mahfiaz gravatar image

updated 2013-05-13 11:52:06 +0200

The better way is to use string concatenation.

Let's say B1 is "It's" and C1 is "cool", then ="I know, " & B1 & " " & C1 will show "I know, It's cool"

If there are numbers which you need special formatting for, then

="Length is " & FORMAT(B1, "0,0") & " mm"

Free tip of the day: Now if you for some reason want to drop the original fields for some reason and leave only the values to this concatenated column, copy it and Edit → Paste special with only "Values" selected.

edit flag offensive delete link more


Oh yeah - that's the better way -- thanks for this (and the tip, too)! FWIW, to concatenate colums B1 and C1 with a space between into a new cell, the syntax is: = B1 & " " & C1

David gravatar imageDavid ( 2013-05-13 13:18:33 +0200 )edit

@David, I'm glad it helped :)

mahfiaz gravatar imagemahfiaz ( 2013-05-13 13:26:50 +0200 )edit

answered 2013-05-13 09:56:32 +0200

David gravatar image

Highlight the cells you want to merge, then right-click. You will get this menu: note the "Merge" option:

Calc: merge cells

Select that option. When you get the prompt: "Should the contents of the hidden cells be moved into the first cell?", click "Yes".

You need to do this on a row-by-row basis. Calc will merge ALL highlighted cells. If you have a lot of cells to merge, you might want to record a macro to automate the process.

There might be a better way, but this is the one I know. Hope that helps!

edit flag offensive delete link more


That would be awesome if this feature still existed. I have LIbreOffice (Ubuntu) and there is no option to merge cells.

fijiaaron gravatar imagefijiaaron ( 2014-10-02 19:50:52 +0200 )edit

@fijiaaron - What's holding you back from updating? I'm also on Ubuntu, and now have V.!

David gravatar imageDavid ( 2014-10-07 12:50:15 +0200 )edit

Question Tools


Asked: 2013-05-13 07:54:49 +0200

Seen: 58,635 times

Last updated: May 13 '13