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, "."))
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, "."))
Yes, with space it's much better.
- i need help
Why don't you start new discussion here https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral and explain what is your question.
- I asked can you check
