How to merge two columns in open office calc

Question

I have two column in open office calc. I want to merge then like following

name    last name  fullname 
john    carter      


name    last name   fullname    
john    carter      john carter

How to do this?

Mukesh · Accepted Answer · 2021-06-17T17:02:41.987

28

I did this like following way In the column where you want to get the merged values write following.

=A2 & " " & B2

and drag to the end of column.

Update: added screenshot

Click on the cell, then hold from the right corner and drag.

edited Jun 17 '21 at 17:02

answered Dec 27 '13 at 07:53

Mukesh

7,630
21
105
159

2

but thats just for fields A2 and B2.. not all of column A and column B – Martin B. Nov 05 '14 at 13:51
@Martin Drag to the end of column. – Mukesh Nov 07 '14 at 19:55
How to drag that? Tried dragging. no results – Jose Cabrera Zuniga Jun 17 '21 at 16:32
1

@JoseCabreraZuniga please check the updated answer. – Mukesh Jun 17 '21 at 17:03

score 8 · Answer 2 · answered Nov 12 '14 at 10:02

8

This is just another option,

just click the function wizard and select 'concatenat', in that enter which column you want to enter as text1 as and second column in text2 then when you click ok you will get an concatenated column like below image

enter image description here

so in the c th column you will get as a1.jpg.

answered Nov 12 '14 at 10:02

Emmanuel Angelo.R

1,545
2
16
24

1

If you need additional formatting characters, enclose them in double quotes and separate them by semi-colon. Ex: =CONCATENATE("[";D4;",";E4;"]") gets me [123,456] where 123 and 456 are from cells D4 and E4 respectively. – Ramson Tutte Dec 31 '14 at 13:21

How to merge two columns in open office calc

2 Answers2