Merging Columns in NeoOffice Calc

From NeoWiki

Jump to: navigation, search

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
Personal tools