How to merge two columns in open office calc

Mukesh picture Mukesh · Dec 27, 2013 · Viewed 42.6k times · Source

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?

Answer

Mukesh picture Mukesh · Dec 27, 2013

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.