Open. Office. org 2. Calc. Before it was possible to import delimited text typically comma or tab delimited into the spreadsheet through a file or a clipboard. Now it is possible to also do it within existing cells. Calc will parse the text and split it apart using whichever delimiter character you choose including tab, comma, space, or semicolon. A delimiter simply means a separator. How to use. Our example spreadsheet contains city and country names delimited by a comma To remove the comma and put the country names into column B, we proceed as follows Make sure there are enough clear cells to accept the new values. Otherwise, the cells will be overwritten. LzA58.png' alt='Openoffice Calc Get Unique Values In Column' title='Openoffice Calc Get Unique Values In Column' />In this case, column B must be empty because the data will grow one column to the right. Highlight the full range of cells in this case, A1 through A4. Click Data Text to Columns. Uncheck the box Tab. Check the box Comma. Click the box OK. Youre done, and here are the results Column options. To specify the type of data in the column, in the preview area click the top of the column. Then, choose a type from the drop down list. AdaptToMarkedSelectionForFilterAreaInCalc.png' alt='Openoffice Calc Get Unique Values In Column' title='Openoffice Calc Get Unique Values In Column' />In many cases, this step is unnecessary. Getting rid of extra spaces. Here are three choices to get rid of extra spaces you may end up with Manually delete them when there are few. Using regular expressions. In the Text to Columns dialog, click Space and Merge Delimiters. This does not work if your data have embedded spaces. Use the TRIM spreadsheet function. In the example above after splitting the cells, you could do this Type TRIMB1 in cell C1. Select cell C1 by clicking on it. There is a square handle protruding from the bottom right hand corner of the cell. Drag it down to cell C4. This copies the formula down. Available Software Sites Eclipse Indigo Version. Copy cells C1 to C4 to the clipboard. Put the cursor in C1 by clicking on it. Responses to Turn off auto complete in libreoffice or openoffice calc and writer. Click Edit Paste Special. Uncheck Paste All and Formulas. Click the OK button. Delete column B. Applications. You can use this feature for a variety of use cases including Splitting city and states such as Los Angeles, California. Splitting last and first names such as Smith, John using a comma. Splitting full names such as Mr. John A. Smith using a space. Splitting fixed width non delimited data such as 2. Cleaning up. csv or. Copying certain tables from a PDF which may be space delimited. Alternatives. There are other ways to convert text to columns Put the data in any other program such as GEdit or Windows Notepad. Then, copy it to the clipboard, and then paste it in Open. View and Download Woodward EasYgen2000 Series user manual online. Genset Control. EasYgen2000 Series Control Panel pdf manual download. Google Spreadsheets supports cell formulas typically found in most desktop spreadsheet packages. These formulas can be used to create functions that manipulate data. Openoffice Calc Get Unique Values In Column' title='Openoffice Calc Get Unique Values In Column' />Office. Calc. You will see the same Text Import dialog when pasting from any external program including Acrobat Reader and Firefox. Save the data to a file with the extension. Then, when you open it in Open. Office. org, youll see the same Text Import dialog. Use Writers text to table feature. Copy the data to the clipboard. Open a Writer document. Click Edit Paste Special. Choose Unformatted Text. Click the OK button. Highlight the text. Click Table Convert Text to Table. Choose the necessary options. Click the OK button. Copy the table. Paste into Calc. Before Open. Office. Text to Columns. OOo version 2. Competition and retraining. Microsoft Excel already has a very similar Text to Columns feature. Both Excel 2. 00. Calc have the feature in the same place. In Excel 2. 00. 7, the feature is roughly in the same place. Excels dialog is a wizard style, so it requires a few more clicks to accomplish the same task. Excel has a few more options, which most people may not need, such as a choice of destination. Related articles.