Document Editing Problems

How to Use Different Separators When Converting Text to Table in Word

Huma Ashraf Ch Sep 25, 2026 869 views

Question details

The user wants to know if it is possible to use one specific character to define table rows and another separate character to create line breaks within individual table cells when converting raw text into a table.

How to Use Different Separators When Converting Text to a Table in Word

Product: Microsoft Word
Device & OS: not provided
Scenario: Converting unstructured or delimited text into a structured table format while needing multi-line text inside specific cells.
Observed behavior: Word uses paragraph marks to define new rows and custom separators for columns, but it does not provide separate custom separator options for both rows and internal cell line breaks simultaneously.

Before you start

Before converting your text to a table, ensure your data is consistently formatted. Review your raw text to verify that columns are divided by a single consistent character (like a comma or tab) and that new rows begin with standard paragraph marks.

Solution 1Recommended

Use Find and Replace to Manage Cell Line Breaks

Since Word does not natively support separate custom separators for rows and internal cell line breaks during conversion, you can use a placeholder text workaround with the Find and Replace tool.

By replacing the characters intended for internal line breaks with a temporary placeholder string before conversion, you prevent Word from treating them as new rows. After the table is generated, you can swap the placeholder back to actual line breaks.

Replace intended line breaks with a placeholder

Press Ctrl+H to open the Find and Replace dialog. In the 'Find what' box, type the character you intended to use for cell line breaks. In the 'Replace with' box, type a unique placeholder string (e.g., '###'). Click 'Replace All'.

Convert the text to a table

Highlight your prepared text. Navigate to the Insert tab on the ribbon, click Table, and select 'Convert Text to Table'.

Set the column separator

In the dialog box, under 'Separate text at', select 'Other' and type the character you are using for columns (e.g., a comma or pipe symbol). Click OK to generate the table.

Restore internal cell line breaks

Select the newly created table and press Ctrl+H again. Type your placeholder ('###') in the 'Find what' box. In the 'Replace with' box, type '^l' (caret followed by a lowercase L) to insert a manual line break. Click 'Replace All'.

Use Find and Replace to Manage Cell Line Breaks

Placeholder Selection: Make sure your placeholder string (like '###' or '%%%') is unique and does not naturally occur anywhere else in your text data to avoid unintended replacements.

Solution 2

Standard Text to Table Conversion

Understand the default behavior of Word's conversion tool to properly format your raw data prior to attempting a conversion.

Easily Convert Text to Tables

Use WPS Writer to Manage Complex Table Conversions

WPS Writer offers a lightweight, intuitive interface with highly compatible formatting tools. You can easily manage complex text-to-table conversions using its robust Find and Replace features to organize your data exactly as needed.

1. Prepare text in WPS Writer: Open WPS Writer and paste your raw data into a new document.
2. Apply a placeholder: Press Ctrl+H to open the Replace tool. Swap the characters meant for internal line breaks with a temporary text placeholder like '###'.
3. Convert text to table: Select the text, navigate to the Insert tab, click Table, and choose 'Convert Text to Table'. Set your column separator in the dialog.
4. Format cell line breaks: Use the Replace tool (Ctrl+H) one last time to change your placeholder ('###') back into manual line breaks ('^l') within the cells.

Advanced Find and Replace for complex character and placeholder managementSeamlessly convert delimited text to customizable tablesFully compatible with Microsoft Word document formats (.docx)Free and lightweight word processing solution

microsoft office alternative - wps office

Frequently Asked Questions

Can I define a custom separator for table rows in Word?

No, Microsoft Word and most standard word processors default to using paragraph marks (created by pressing Enter) to define new rows when converting text to a table. The custom separator option is exclusively used to define columns.

What is the code for a manual line break in the Find and Replace dialog?

In the Find and Replace dialog, you can use the code '^l' (a caret symbol followed by a lowercase L) to find or insert a manual line break. This is highly useful for formatting multi-line text inside table cells.

How do I separate columns using a custom character?

When using the Convert Text to Table feature, look under the 'Separate text at' section. Select the 'Other' radio button and type your desired character, such as a pipe symbol (|), an asterisk (*), or a semicolon (;), into the small text box next to it.

Document & File Issues