Merging Columns in NeoOffice Calc

You can merge two or more columns in a spreadsheet without merging them cell by cell. In order to do that, proceed as follows:

Copy (Cmd-C) the content of the columns you want to merge
Open a new Calc document
Paste (Cmd-V) the content of the columns
Save the document in .csv format
- Choose Text CSV (.csv) in the pop-down File type menu
- Check Edit filter settings
- Choose a name and a location for your file
- Click Save
- Press Yes to close the "may loose formatting" dialogue
In the Export of text files window, choose "{space}" in the Field delimiter field, and leave Text delimiter set on: "
Click OK
Open the .csv file you just created
In the Text Import window, in the Separated by section, uncheck Space (if it's checked). All the checkboxes have to be unchecked.
Click OK
A spreadsheet appears, in which the columns are merged
Go to the Edit menu, and choose Find and Replace
In the Search for field type: "
Leave the Replace with field empty
Click on Replace All
Copy this column and paste it into your initial document

This method applies to any number of adjacent columns.

This article in other languages: FranÃ§ais Italiano