Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to merge two columns in open office calc [closed]

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?

like image 247
Mukesh Avatar asked Dec 27 '13 07:12

Mukesh


2 Answers

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. enter image description here

like image 175
Mukesh Avatar answered Sep 25 '22 10:09

Mukesh


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.

like image 28
Emmanuel Angelo.R Avatar answered Sep 22 '22 10:09

Emmanuel Angelo.R