Forum Discussion
Solved
Extracting sentences from a cell
Hi. I have a cell full of sentences. I need to extract each sentence into new adjacent cells. Thank you.
Does each sentence end in a full stop (point)? If so, you could use Data > Text to Columns, with . as delimiter.
If you have Microsoft 365, you can use a formula:
=TRIM(TEXTSPLIT(A1, "."))
It depends on what do you mean under sentence (how they are separated within the text) and on which Excel version/platform you are.
- Hi Sergei, they are separated by a period; I copied and pasted from Word to an Excel cell and I need the sentences to be separated in adjacent cells in a column (not a row). The advice from hans above is excellent and appreciated, but I now need to know how to organize them into adjacent cells in a column.
