Merging Columns in NeoOffice Calc

From NeoWiki

Revision as of 09:58, 15 August 2007 (edit) Sardisson (Talk | contribs) (some tiny polish while tired; thanks jacqueline!) ← Previous diff		Current revision (23:18, 23 December 2007) (edit) (undo) Valterb (Talk | contribs) (botlangbar -> IT)
Line 23:		Line 23:
	This method applies to any number of adjacent columns.		This method applies to any number of adjacent columns.
-	{{botlangbarEN|[[Fr:Fusionner des Colonnes dans NeoOffice Calc |Français]]}}	+	{{botlangbarEN|[[Fr:Fusionner des Colonnes dans NeoOffice Calc |Français]] [[It:Unire_Colonne_in_Calc|Italiano]]}}
	[[Category:Tips and Hints]][[Category:NeoOffice]]		[[Category:Tips and Hints]][[Category:NeoOffice]]

---

Current revision

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.