How to merge two columns in open office calc
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?
Solution
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.
- How to prevent OpenOffice/LibreOffice Calc from changing what you input (data, numbers,...)
- Openoffice.org Calc - Assigning value to variable
- Formula to return random string from list of strings?
- Libreoffice Calc Basic macro to combine sheets with different number of columns
- Table containing the count of multiple columns?
- read data from multiple spreadsheets into database
- How to run a formula until it meets a certain criteria?
- How to subtract a time constant in a LibreOffice/OpenOffice/Excel formula?
- Find last column with data and return the header of that column
- LibreOffice Calc: Find a cell by value
- highlight duplicate Value in Open Office org Calc
- Excel Having issues with an ODS file created with SODS
- How do you use " (double quotes) in a formula in OpenOffice VBA? For instance with Replace()
- Highlight duplicate values
- extract number from cell in openoffice calc
- Using OLE, remove all sheets except first one from a OpenOffice/LibreOffice Calc document, without using sheet names
- Create floating button to add/subtract values to/from cells in spread sheet
- How to run a script from another document
- Libreoffice/Openoffice Calc - append string to cells
- Error with Roo . Any gems to parse .ods files
- Charts created by EPPlus 4.1 library in .xlsx format are not displaying in openoffice or libreoffice
- LibreOffice Calc / OpenOffice Calc / Excel: How to display a negative time duration?
- How to merge two columns in open office calc
- Assign Category Values according to wildcards in assignment table
- OpenOffice Calc sum of number less then a value
- Size difference between python generated csv and converted xlsx file
- Sort uppercase cells separately from lowercase ones
- Ignore any number in the tenth position in Open Offic Calc
- Summing and averaging data in openrefine or libre office
- Is there a way to extract a substring from a cell in OpenOffice Calc?