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?
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.