Merging Columns in NeoOffice Calc

From NeoWiki

(Difference between revisions)
Jump to: navigation, search

Jgd (Talk | contribs)
(New page: You can merge two or several columns in a spreadsheet, without merging them cell by cell. In order to do that, proceed in the following way: *Copy ({{key| Cmd-C}}) the content of the colum...)
Next diff →

Revision as of 08:28, 15 August 2007

You can merge two or several columns in a spreadsheet, without merging them cell by cell. In order to do that, proceed in the following way:

  • 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 .cvs format
    • Choose Text CVS (.cvs) 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 .cvs 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 empty the Replace with field
  • Click on Replace All
  • Copy this column and paste it in your initial document;

This method applies to any number of adjacent columns.


This article in other languages: Français
Personal tools