merging column in libreoffice calc does not work when drag down

Question

I'm merging columns in Libre Office using the CONCATENATE function. I'm merging all text using:

CONCATENATE(A1," ",B1," ",C1," ",D1," ",E1," ",F1," ",G1)

According to this suggestion, I should be able to apply the function over the whole column by dragging the plus sign; however, when I drag the plus sign, it only copies the first line, but I want to merge the next row.

How can I merge the columns correctly?

score 1 · Accepted Answer · answered Apr 04 '13 at 12:42

1

@oczdref, I am not sure why this would not work in your situation. Here is what I did (please ignore the ; separators, in your case they should remain ,)

enter image description here

answered Apr 04 '13 at 12:42

Robert Ilbrink

7,738
2
22
32

score 0 · Answer 2 · answered Apr 05 '13 at 02:22

0

I also found out that you must enable the "AutoCalculate" under Tools -> Cell contents so that when you drag the autocomplete function instead of getting the result something like this:

enter image description here

and the result that i want to.

enter image description here

answered Apr 05 '13 at 02:22

oczdref

534
1
6
15

merging column in libreoffice calc does not work when drag down

2 Answers2