How to Extract Separate Sentences from One Excel Cell in WPS Office Spreadsheets
Question details
The user needs to split multiple sentences stored in a single spreadsheet cell into separate adjacent cells, using the full stops between sentences as break points.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A worksheet cell contains several full sentences separated by periods, and the user wants each sentence in its own cell for sorting, filtering, or editing.
- Observed behavior
- All sentences remain combined in one cell, so individual sentences cannot be manipulated independently.
Before splitting, check that your sentences are consistently separated by full stops and that the adjacent cells to the right are empty, because Text to Columns writes the split parts into those cells.
Split Sentences with Text to Columns in WPS Spreadsheets
Use this method when the sentences are separated by full stops and you want a formula-free, built-in way to split them into adjacent columns.
The Text to Columns wizard in WPS Spreadsheets treats the period as a delimiter and writes each split part into the cells to the right of the original cell.
This works best when the cell text is clean and periods are used only as sentence separators.
Open the workbook in WPS Office Spreadsheets and select the column or range that contains the multi-sentence cells.
Click the Data tab on the ribbon, then click Text to Columns.
In the Convert Text to Columns dialog, select Delimited and click Next.
Clear all default delimiter check boxes, check Other, enter a period (.) in the box, then click Next.
Leave the destination as the original cell or select another empty column, set the column data format if needed, and click Finish.
Split Multi-Sentence Excel Cells with WPS Office Spreadsheets
Use the built-in Text to Columns wizard in WPS Spreadsheets to separate full-stop-delimited sentences into adjacent cells without formulas or extra add-ins.
- 1. Install and open WPS Office: Download WPS Office, install it, and open the workbook in WPS Spreadsheets.
- 2. Select the multi-sentence cells: Select the column or range where multiple sentences are stored in one cell.
- 3. Open Text to Columns: Click the Data tab, then click Text to Columns and choose Delimited.
- 4. Use the period delimiter: In the delimiter options, check Other, type a period (.) in the box, and review the data preview.
- 5. Finish and check the result: Choose the destination and click Finish; the separated sentences appear in adjacent cells.
Frequently Asked Questions
Can I split sentences in WPS Spreadsheets without a formula?
Yes. Use Data > Text to Columns, choose Delimited, enter a period (.) as the Other delimiter, and click Finish.
What happens to the original cell after Text to Columns?
The original cell keeps the first part of the split text, and the remaining parts are written into adjacent cells to the right. Use the Destination option if you want to keep the original cell unchanged.
Does this method work if sentences end with other punctuation?
Yes. In the delimiter step, enter the actual character that separates the sentences, such as a question mark, exclamation mark, semicolon, or comma.
Can I split sentences into rows instead of columns?
Text to Columns writes the split results into columns. To place them in rows, split them first and then copy the result and use Paste Special > Transpose.
Will splitting by a period break abbreviations or decimals?
It can, because every period is treated as a delimiter. Review the data preview carefully and clean the text or use a different separator if abbreviations or decimal numbers should stay intact.
