Text Separator Options
See Also
This dialog allows you to specify the separator characters for splitting text into separate cells when creating a spreadsheet from either the clipboard or a text file, or pasting the clipboard to an existing spreadsheet. This menu will be displayed if the text is not tab delimited.

You can specify the characters to be used as separators by selecting one or more of the following options.
SpaceUse a space ' ' as a separator.
CommaUse a comma ',' as a separator.
SemicolonUse a semicolon ';' as a separator.
OtherProvides a space for you to specify the characters to be used as separators in the box provided.

Don't show this menu again this session

Controls whether this menu is displayed each time you paste data that is not tab delimited or create a spreadsheet from a text file which does not have tab delimited text. When selected, clicking Yes will ensure that the chosen separators are used to split text until you start a new session. If you click No, then the text will not be split in any further operations until you start a new session.

Yes

Use the specified characters as separators for the data on the clipboard.

No

Do not split the text. All the characters on a line will be placed in one cell.

Cancel

Close the dialog without pasting to the spreadsheet or creating a new spreadsheet from the text.

See Also