Splitting text into multiple columns

<< Click to Display Table of Contents >>

Splitting text into multiple columns

FreeOffice: The command Text to columns is not included in SoftMaker FreeOffice.

By choosing the ribbon command Data | group Edit | Text to columns, you can split text that is in one worksheet cell into multiple worksheet 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 that contains the text to be distributed across columns.
(You can also select multiple cells or even an entire column.)
2.Choose the ribbon command Data | group Edit | Text to columns text_to_columns_icon.
3.The program displays a dialog box with several options (see below).
PlanMaker usually makes all the settings in it automatically, and you don't have to change anything.
4.Confirm with OK.

The text in the cell will then be distributed across multiple columns.

Options of the dialog box

Tip: The best settings for this dialog box are determined automatically upon analysis of the cell contents and usually do not need to be changed.

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 then be placed in the specified target position rather than in its original position.
You only have to specify 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 selects a space as a separator and thus distributes each word to a column.

Text marker

If the text in the cell contains text markers, use this option to specify which character has been used (for example, quotation marks).
Background info:
The text export feature of some programs surrounds each data field with such a text marker in order to make it easy to determine where each field begins and ends.