FreeOffice: The Text to columns command is not included in SoftMaker FreeOffice.
With the ribbon command Data | group Edit | Text in columns you can distribute text entered in one table cell into multiple columns. If, for example, a cell contains a sentence, this command will move each single word into its own column.
You apply this command as follows:
| 1. | Navigate to the cell containing the text to be distributed. |
| (You can also select multiple cells or even an entire column.) |
| 2. | Choose the ribbon command Data | group Edit | Text in columns  . |
| 3. | The program displays a dialog box with several options (see below). |
| As a rule, PlanMaker determines appropriate settings for this dialog box automatically, so you don't have to care about it. |
The text in the cell is distributed over several columns.
Options of the dialog box
Tip: The best settings for this dialog box are determined from the given cell content automatically. Usually, no manual changes are required.
The dialog box for this command has the following options:
▪Target range
| If desired, you can enter a different target range here. If you do so, the distributed text will not be placed at its original position, but at the specified target position. |
| It is sufficient to enter just the address of the cell in the top left corner of the target position. |
▪Separator
| If required, you can specify which character PlanMaker should consider as a text separator here. If, for example, the cell contains the sentence "This is a test", PlanMaker automatically chooses blanks as separators, which will move each word of the sentence into one column. |
▪Text marker
| If the text in the cell contains text marker characters, use this option to specify which character has been used (e.g. quotation marks). |
| (Background info: The text export feature of some programs surrounds each data field with such a character, in order to make it easy to determine where a data field begins and ends.) |